Women in Technology

Hear us Roar



Article:
  SQL Data Types
Subject:   how do we find nth highest in SQL
Date:   2006-05-19 05:24:47
From:   SPKUMAR
Response to: how do we find nth highest in SQL

ok
Full Threads Newest First

Showing messages 1 through 5 of 5.

  • how do we find nth highest in SQL
    2006-07-11 22:39:42  prasanna1729 [View]

    how do we find nth highest in SQL
    • 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:42  viren_19 [View]

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