SELECT salary FROM (SELECT ROW_NUMBER() OVER (ORDER BY salary desc) AS RN

find the 3rd max salary

Question Posted / cpnagar

Answer Posted / cpnagar

SELECT salary FROM (SELECT ROW_NUMBER() OVER (ORDER BY
salary desc) AS RN,*
FROM
emp)temp
WHERE
RN=3

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is difference between materialized view and view?

954

Can we call future method from queueable?

1097

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

152

what is a transaction? : Sql server database administration

1052

What are information schema views?

1030

What is equi join with example?

1230

How to update a field in SQL after ALTERING a row?

1286

How do I create a trace in sql server?

1091

How to count rows with the count(*) function in ms sql server?

1060

Is sql server a database?

1040

What are the different ways you can create databases in sql server?

1155

what is database replication? : Sql server database administration

1129

What is the command dbcc checkdb used for?

1073

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

944

How do you open a cluster administrator?

1097