Article:
  SQL Data Types
Subject:   how do we find nth highest in SQL
Date:   2004-10-13 04:11:13
From:   sunrek
Response to: how do we find nth highest in SQL

can u please help me
Full Threads Oldest First

Showing messages 1 through 7 of 7.

  • how do we find nth highest in SQL
    2005-10-17 23:31:59  Apurva_Sharma [View]

    Hi,
    Solution to your query.Plz follow steps.

    Steps
    SQL> SET Verify OFF;

    SQL> SELECT min(sal)
    FROM (SELECT sal
    FROM emp
    order by sal desc)
    WHERE rownum<(&nth_heighest+1);
  • how do we find nth highest in SQL
    2004-11-14 21:40:07  Question&answer [View]

    To find the nth highest salary as below

    select max(a.sal) from emp a where &n=(select count(b.sal) from emp b where (a.sal output-
    put the value of n and get the highest salary that u have give the number i;e 4,5,6,10 etc.

    thanx,
    Haribrat

    • how do we find nth highest in SQL
      2004-12-11 08:17:00  RuchirAwadhawal [View]

      Query for Nth Max (Highest)
      select sal from emp t
      where &n = (select count(sal)
      from (select distinct sal from emp)
      where t.sal<=sal);

      <b>Query for Nth Min (Lowest)
      select sal from emp t
      where &n = (select count(sal)
      from (select distinct sal from emp)
      where t.sal>=sal);
      • how do we find nth highest in SQL
        2005-01-18 21:03:32  hiexplain [View]

        thanks a lot
        "select sal from emp t
        where &n = (select count(sal)
        from (select distinct sal from emp)
        where t.sal<=sal);"
        it is working fine
        could u please let me know how it works...
        thanks and reguards
        surendra
    • how do we find nth highest in SQL
      2004-12-11 08:16:41  RuchirAwadhawal [View]

      Query for Nth Max (Highest)
      select sal from emp t
      where &n = (select count(sal)
      from (select distinct sal from emp)
      where t.sal<=sal);

      <b>Query for Nth Min (Lowest)
      select sal from emp t
      where &n = (select count(sal)
      from (select distinct sal from emp)
      where t.sal>=sal);
      • query for nth max
        2007-08-25 02:05:46  kashif094 [View]

        select * from emp e where 1=(select count(distinct sal) from emp where e.sal<=sal)



        hi i am kashif can anyone tell me what is the concept of 1 in this query?
        • query for nth max
          2007-10-25 05:02:21  jolly_cet [View]

          1 specifies the position..