||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 1 of 1.
how do we find nth highest in SQL
2009-10-13 11:57:45 Sandip D [View]