SQL : nth highest salary from emp table

ygsunilkumar

select distinct (a.salary) from employees a
where &N = (select count (distinct(b.salary))
from employees b where a.salary <= b.salary);

Pls any one explain how the query works, logic behind it.

r035198x

Which part don't you understand? Split it up and try to understand each part separately first.

SQL : nth highest salary from emp table

re: SQL : nth highest salary from emp table

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about