sql - Group By 子句中的别名 - 标识符无效

Question

这个问题已经有答案了:

SQL - using alias in Group By (10 个回答)

已关闭 5 年前。

我尝试了很多方法，但无法解决这个问题......

我正在执行 Oracle SQL 查询:

SELECT
    TRUNC(months_between(sysdate, DateofBirth) / 12) AS "age"
FROM players
group by age
HAVING COUNT 
    (TRUNC(months_between(sysdate, DateofBirth) / 12)) > 30;

ERROR at line 4: ORA-00904: "AGE": invalid identifier

有什么想法吗？

Answer 1

不要在您的组中添加别名:

SELECT
    TRUNC(months_between(sysdate, DateofBirth) / 12) AS "age"
FROM players
group by
    TRUNC(months_between(sysdate, DateofBirth) / 12)
HAVING
    COUNT(TRUNC(months_between(sysdate, DateofBirth) / 12)) > 30;