How to find 6th highest salary from Employee table ?
Answer Posted / krishan kant
SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT
DISTINCT TOP 6 SALARY FROM EMPLOYEE ORDER BY SALARY
DESC)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is explicit cursors?
What are the restrictions applicable while creating views? : SQL Server Architecture
What is faster join or union?
How can you find out which stored procedures are recompiling?
Can a table be moved to different filegroup?
Why use cursor in sql server?
Define Unique Key?
What is difference between delete & truncate commands?
Tell me what is de-normalization and what are some of the examples of it?
What is the Disadvantage of indexed sequential file.
What are the database roles? : sql server security
Can you explain what are commit and rollback in sql?
What options are available to audit login activity? : sql server security
Difference between DELETE and TRUNCATE?
What is the log shipping?