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 cached report?

143

Why use “pivot” in sql server?

1089

How to drop an existing user defined function in ms sql server?

1014

How to use "begin ... End" statement structures in ms sql server?

1013

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

Relational calculus is what type of language?

1013

Can you please explain the difference between function and stored procedure?

985

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

944

What is dknf in normalization form?

1031

What are types of subqueries?

1036

What is a fan-out query in SQL Azure?

121

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1230

What are the reporting services components?

142

What is a natural primary key?

1001

Determine when an index is appropriate?

1050