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 transaction server consistency?

982

What is sql server profiler trace data file?

1052

Can an automatic recovery be initiated by a user?

943

Explain what is “asynchronous” communication in sql server service broker?

872

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

941

Can you always create a cache of a report?

156

What is a select query statement in ms sql server?

1009

How to create an index on a view?

991

What are system databases into sql server (2005/2008)?

956

How to Insert multiple rows with a single insert statement?

1002

What is the web service used for reporting services?

114

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

916

Can a function call a stored procedure in sql server?

911

How to create new table with "create table" statements?

998

What is a group function explain with an example?

940