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

Explain a join?

1047

Explain about extended stored procedure?

914

Explain various On-Delete options in a DB table. Which is the default option?

1449

What is a hint?

973

What is the purpose of the tempdb database?

984

what is a transaction and what are acid properties? : Sql server database administration

1007

What is default port number for sql server 2000?

1025

What is key set driven?

932

What are the basic functions for master, msdb, model, tempdb and resource databases?

970

What is function of master database?

114

Explain what are partitioned views and distributed partitioned views?

930

How to populate a table in sql server?

942

What types of replication are supported in sql server?

1048

Explain log shipping?

997

What is global temp table?

984