forum

Home / DeveloperSection / Forums / How to find the Nth maximum and minimum value in sqlserver.

Ask Question
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

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
answer 415871301102353

 

Liked By