How to find the Nth maximum and minimum value in sqlserver.

Anonymous User 1913 13 Jan 2016

I want to To find the Nth maximum and minimum value in sqlserver.

Anonymous User

Other

I am a content writter !

1 Answers

Anonymous User 13 Jan 2016

DECLARE @table TABLE(ID integer,AMOUNT integer)
INSERT INTO @table values(1, 5000)
INSERT INTO @table values(2, 200)
INSERT INTO @table values(3, 4500)
INSERT INTO @table values(4, 3000)
INSERT INTO @table values(5, 3200)
INSERT INTO @table values(6, 3100)
INSERT INTO @table values(7, 150) 
SELECT ID, AMOUNT
FROM
(
SELECT ID, AMOUNT, Row_Number() OVER(ORDER BY AMOUNT DESC) AS highest
FROM @table
) as x
WHERE highest = 1
SELECT id, AMOUNT
FROM
(
SELECT id, amount, Row_Number() OVER(ORDER BY AMOUNT ASC) AS lowest
FROM @table
) as x
WHERE lowest =1

forum

How to find the Nth maximum and minimum value in sqlserver.

Can you answer this question?

1 Answers