select column_name from
(select table_name.*,dense_rank() over (order by column_name desc) rank from table_name)
where rank = &N;
select * from
(select AdventureWorks.Sales.Store.*,dense_rank() over
(order by SalesPersonID ) rank from AdventureWorks.Sales.Store) a
where rank = 2