Women in Technology

Hear us Roar



Subject:   how do we find nth highest in SQL
Date:   2006-07-11 22:39:42
From:   prasanna1729
Response to: how do we find nth highest in SQL

how do we find nth highest in SQL
Full Threads Oldest First

Showing messages 1 through 4 of 4.

  • how do we find nth highest in SQL
    2006-08-17 04:21:32  navingujar [View]

    One more way, select min(sal) from (select distinct sal from emp order by sal desc) where rownum <=n
  • how do we find nth highest in SQL
    2006-08-17 04:21:27  navingujar [View]

    One more way, select min(sal) from (select distinct sal from emp order by sal desc) where rownum <=n
    • how do we find nth highest in SQL
      2006-11-13 01:13:53  viren_19 [View]

      how do we find nth highest in SQL
    • how do we find nth highest in SQL
      2006-11-13 01:13:42  viren_19 [View]