advertisement

Subject:   how do we find nth highest in SQL
Date:   2006-08-17 04:21:27
From:   navingujar
Response to: how do we find nth highest in SQL

One more way, select min(sal) from (select distinct sal from emp order by sal desc) where rownum <=n
Full Threads Oldest First

Showing messages 1 through 2 of 2.

  • how do we find nth highest in SQL
    2006-11-13 01:13:53  viren_19 [Reply | 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 [Reply | View]