||SQL Data Types|
|Subject:||how do we find nth highest in SQL|
Response to: how do we find nth highest in SQL
With qry1 as (Select col1, col2, rownumber() over ()rownum from tablename order by col2 DESC)
select * from qry1 where rownum=6;
Showing messages 1 through 2 of 2.