Toad World® Forums

ORA-00904: "SALARY": invalid identifier


#1

Hello all,
I have the next query with the issue ORA-00904: “SALARY”: invalid identifier
Would you help me please?

select job_id, salary
from ( select job_id, max(salary) salaries
from hr. employees
group by job_id
) x ;


#2

try “select job_id, salaries from…” instead.