Dear all,
may I ask whether there is a deeper reason why using a column alias in the same
SELECT query doesn't work, e.g.
SELECT column1 AS a, 5*column2 AS b, a+b FROM...
This is not an SQlite issue, it doesn't work in MariaDB either. It would,
however, be very handy if it worked. Sometime
On 31 Oct 2018, at 7:14pm, Thomas Kurz wrote:
> may I ask whether there is a deeper reason why using a column alias in the
> same SELECT query doesn't work, e.g.
>
> SELECT column1 AS a, 5*column2 AS b, a+b FROM...
The canonical answer to this is that there's nothing in the SQL specificati
On 2018/10/31 9:21 PM, Simon Slavin wrote:
On 31 Oct 2018, at 7:14pm, Thomas Kurz wrote:
may I ask whether there is a deeper reason why using a column alias in the same
SELECT query doesn't work, e.g.
SELECT column1 AS a, 5*column2 AS b, a+b FROM...
The canonical answer to this is that
Thank you very much for the detailed answer. I now understand things better and
can better accept that they are how they are :-))
- Original Message -
From: R Smith
To: sqlite-users@mailinglists.sqlite.org
Sent: Wednesday, October 31, 2018, 21:34:30
Subject: [sqlite] use column alias
4 matches
Mail list logo