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

What is a with(nolock)?

972

Do you know concepts and capabilities of sql server?

1045

Can you explain about buffer cash and log cache in sql server?

934

What is the latest version of microsoft sql server?

1026

Explain different types of collation sensitivity?

964

How to view existing indexes on an given table using sys.indexes?

1075

What is ssl in sql server?

1062

What are the advantages to use stored procedures?

1085

Explain subquery and state its properties?

1024

What are the common performance issues in sql server?

902

Is it possible to call a stored procedure within a stored procedure?

952

What is logon trigger?

1074

Where are sql server user names and passwords stored in sql server?

1067

What is a trace frag? Where do we use it?

1087

What is SubQuery in SQL Server 2008

1007