Question

我有一个库中的表，为什么select 一个字段就报ORA-00904错误

Answer 1

where 语句后面，"入职天数"是一个别名，不能用在这里。
select * from
( select ename,sal,trunc(sysdate-hiredate) as "入职天数" from scott.emp where sal<=1200 ) a where "入职天数">=10000 order by sal,"入职天数";