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 indexing and its types?

1060

What is intellisense?

1102

What are types of storage modes? : sql server analysis services, ssas

1087

What is the use of commit?

1063

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

981

What are the advantages of policy management?

1046

How to replace given values with null using nullif()?

1040

To which devices can a backup be created and where should these devices be located? : sql server management studio

1103

what is a live lock? : Sql server database administration

1021

Difference between group by clause and having clause in SQL?

1029

How to delete a login name in ms sql server?

1128

What is inline variable assignment?

1082

Do you know what is rank function?

1128

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

940

Mention the differences between local and global temporary tables.

1110