取得某列中第n大的行 使用dense_rank()函数

 

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