sql - ORA-00904 无效标识符错误

Question

我收到 ORA-00904 'c' 无效标识符错误。这个别名有什么问题？

select NO, count(JOINT_NO) as c
from JOINT
WHERE HOLDER = 'Y' AND JOINT.c > 1
GROUP BY NO;

Answer 1

我想你想获取那些计数 > 1 的记录。所以你不能在同一查询的 WHERE 子句中使用 Indentifier C。

select NO, count(JOINT_NO) as c
from JOINT
WHERE HOLDER = 'Y'
GROUP BY NO
HAVING COUNT(JOINT_NO)>1;