在SQL计算中使用别名

只需将您的重用别名包装为

(SELECt alias)

SELECT 10 AS my_num,        (SELECT my_num) * 5 AS another_numberFROM table