[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.