Here I will going to give you a quick
Query to find the nth row from table in
SQL SERVER.
- select * from (select *,dense_rank() over(order by amount desc)rank from dattahaltingdetails)as tab where tab.rank=5
So, what is dense_rank() ?
DENSE_RANK gives you the ranking within consecutive ordered partition, No ranks are skipped if there are ranks with multiple items. It will gives same rank for duplicate column value.