|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 1 of 1.
how do we find nth highest in SQL
2006-10-17 02:09:39 Asha_S [View]