er # 9 select top 1 * from ( SELECT DISTINCT TOP 3 salary FROM tblemp

find the 3rd max salary

Question Posted / rajasekar

Answer Posted / rajasekar

er
# 9
select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain how to use linked server?

999

Can you pass expressions to function parameters?

1107

Is sql server implemented as a service or an application? : Sql server database administration

973

What are different types of roles provided by ssrs?

152

How data can be copied from one table to another table?

956

Is sql server a database?

1006

Define outer join in sql server joins?

941

What is difference between clustered and non clustered index?

993

Write a sql query to delete duplicate records from a table called table1

1041

What function does a database engine serve in the sql server?

1043

What is the Main Difference between ACCESS and SQL SERVER?

1146

How to create median function?

166

Can you explain different types of locks in sql server?

952

how to invoke a trigger on demand? : Sql server database administration

1091

Which sql server is best?

1003