Article:		SQL Data Types
Subject:		how do we find nth highest in SQL
Date:		2005-01-28 13:02:12
From:		parangogoi
Response to: how do we find nth highest in SQL
Please help me with the above query

Showing messages 1 through 3 of 3.

• how do we find nth highest in SQL
  2005-10-17 23:29:32  Apurva_Sharma [Reply | 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
  2005-10-30 09:21:35  bhaskarreddy [Reply | View]
  
  
  select * from emp e where 1=(select count(distinct sal) from emp where e.sal<=sal)
  if u want to print the second highest sal. replace 1 with 2.
  
• how do we find nth highest in SQL
  2006-10-17 02:09:39  Asha_S [Reply | View]
  
  
  very useful query for interviews... thanks