5th highest amount

Question

how to get 5th highest amount from a product table.

Pankaj Pandey · Answer

try it.. SELECT * FROM ( SELECT DENSE_RANK() OVER (ORDER BY amount DESC) AS rownumberamount FROM product) AS Maxs WHERE rownumber = 5

Riyaz Akhtar · Answer

Find below the solution if you are using sql server 2005 or above: with result as ( select ROW_NUMBER() OVER (ORDER BY id) AS [row_number]* from Product ) select * from result where [row_number]=5