Women in Technology

Hear us Roar



Subject:   how do we find nth highest in SQL
Date:   2005-10-30 09:21:35
From:   bhaskarreddy
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.
Full Threads Oldest First

Showing messages 1 through 2 of 2.

  • how do we find nth highest in SQL
    2006-10-17 02:09:39  Asha_S [View]

    very useful query for interviews... thanks
    • how do we find nth highest in SQL
      2010-05-11 00:05:08  vish44 [View]

      This query only work till 3rd highest, after that it gives 4th highest when we set n=7