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
Explain the difference between clustered and non-clustered index?
Explain unique key in sql server?
Explain about thread and memory management process of SQL?
What are transactions and its controls?
What is an identity?
What are data regions?
What is read uncmmited?
What is the significance of null value and why should we avoid permitting null values?
Is a primary key unique?
Can we use where and having clause together?
Tell me what is the stuff and how does it differ from the replace function?
What is a view in sql?
What is data compression?
Why we use functions in sql server?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas