|Subject:||how do we find nth highest in SQL|
Response to: how do we find nth highest in SQL
select * from emp e where 1=(select count(distinct sal) from emp where e.sal<=sal)
if u want to print the second highest sal. replace 1 with 2.
Showing messages 1 through 2 of 2.