Article:		SQL Data Types
Subject:		how do we find nth highest in SQL
Date:		2005-09-25 23:55:04
From:		lalitpant
Response to: how do we find nth highest in SQL

Showing messages 1 through 1 of 1.

• how do we find nth highest in SQL
  2005-10-17 23:28:21  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);