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 the most common trace flags used with sql server?

1113

how to create “alternate row colour”?

152

How to execute a sql statement using odbc_exec()?

1212

What are different types of table joins?

1050

Can group by and orderby be used together?

1065

How many categories of data types used by sql server?

1051

Explain view in sql server?

1084

How to list all login names on the ms sql server?

1177

What are views in ms sql server?

1118

Does transparent data encryption provide encryption when transmitting data across the network?

1096

Does a sql server 2005 select statement require a from?

1069

What are the aggregate and scalar functions?

1128

What is the purpose of data source?

1084

What xml support does the sql server extend?

1053

Explain primary key and foreign key constraints?

1085