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 set nocount on and what is set nocount off?

886

What is snapshot report?

154

How do we Backup SQL Azure Data?

106

Your table has a large character field there are queries that use this field in their search clause what should you do?

854

How to turn off warning messages during php execution?

984

what are the different stages of Report Processing?

125

How many replicas are maintained for each SQL Azure database?

140

Can you index views?

853

Explain what is sql server english query?

988

Explain Geometry datatype in sql server 2008 with example

921

what is the difference between count(*) and count(1) ?

1028

How you can add messages to the nt event log from within a stored procedure?

998

What is a result set object returned by mssql_query()?

1078

Can we add a cpu to sql server?

960

How to use values from other tables in update statements in ms sql server?

1040