访问select语句中的前一个'synthetic‘列

Question

如果我有一个像这样的select语句

SELECT 
   t.time,
   <complicated computation> AS ticks,
   <is it possible to access the value of the ticks row here?> as num
FROM
   MyTable t;

我可以使用第二列的计算值作为第三列计算的基础吗？

Answer 1

您需要将其包装在子查询中:它将如下所示：

SELECT
    i.time as time,
    i.ticks as ticks,
    i.ticks + 10 as num
FROM
(
    SELECT 
       t.time as time,
       5 AS ticks
    FROM
       MyTable t
) AS i;