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
Main Topics Newest First

Showing messages 1 through 2 of 2.

  • 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-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