SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT DISTINCT TOP 6 M

How to find 6th highest salary from Employee table ?

Question Posted / answer

Answer Posted / answer

SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT
DISTINCT TOP 6 MAX (SALARY) FROM EMPLOYEE ORDER BY SALARY
DESC)

Is This Answer Correct ?

16 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Can you use order by when defining a view?

981

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1065

Write a query to find 5th highest amount paid from the customer table.

935

What is difference between view and materialized view?

941

How do you run a trace?

908

How do you delete duplicate rows in sql server?

964

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

906

What the class forname () does?

1073

What is cte (common table expression)?

1040

What are the advantages of user defined function?

988

List down some advantages of sql stored procedure?

970

What type of Index will get created after executing the above statement?

1103

What is the impact on other user sessions when creating indexes?

927

What is dimension table? : sql server analysis services, ssas

1025

Explain how many types of relationship?

1034