How to find 6th highest salary from Employee table ?
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 |
Post New Answer View All Answers
What is indexing and its types?
What is intellisense?
What are types of storage modes? : sql server analysis services, ssas
What is the use of commit?
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?
What are the advantages of policy management?
How to replace given values with null using nullif()?
To which devices can a backup be created and where should these devices be located? : sql server management studio
what is a live lock? : Sql server database administration
Difference between group by clause and having clause in SQL?
How to delete a login name in ms sql server?
What is inline variable assignment?
Do you know what is rank function?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Mention the differences between local and global temporary tables.