Article:		SQL Data Types
Subject:		how do we find nth highest in SQL
Date:		2004-10-08 07:32:14
From:		gansin
Please give the query for the finding the nth highest salary in SQL.

Showing messages 1 through 5 of 5.

• how do we find nth highest in SQL
  2007-11-21 02:20:53  Ani123 [Reply | View]
  
  
  With qry1 as (Select col1, col2, rownumber() over ()rownum from tablename order by col2 DESC)
  select * from qry1 where rownum=6;
  
  This finds the 6th highest;

• how do we find nth highest in SQL
  2006-05-19 05:24:47  SPKUMAR [Reply | View]
  
  
  ok

• how do we find nth highest in SQL
  2005-09-25 23:55:04  lalitpant [Reply | View]
  
  

• how do we find nth highest in SQL
  2005-01-28 13:02:12  parangogoi [Reply | View]
  
  
  Please help me with the above query

• how do we find nth highest in SQL
  2004-10-13 04:11:13  sunrek [Reply | View]
  
  
  can u please help me