SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 6 salary FROM employee ORDER

How to find 6th highest salary from Employee table ?

Question Posted / saravakumar

Answer Posted / saravakumar

SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 6 salary FROM
employee ORDER BY salary DESC) a ORDER BY salary

Is This Answer Correct ?

30 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is collation sensitivity? Explain different types.

1021

Which rendering formats are affected by the pagesize properties?

147

How to delete duplicate rows in sql server?

1118

Do you know what is blocking?

970

Explain filestream storage of sql server 2008?

1025

In case you have filters in your report, when filters will be applied in cached report instance?

115

What are the advantages of log shipping?

1003

How to start sql server browser service?

1148

What is the difference between clustered and a non-clustered index?

1038

Explain concepts of analysis services?

973

Does group by sort data?

909

What is lock escalation? : sql server database administration

1169

How can we migrate from SQL server to SQL Azure?

113

What is the full form of ddl?

939

Explain can you implement data mining in ssrs?

161