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 are the five major components of a dbms?
What are the advantages to use stored procedures?
Who developed sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What program is used to store the data source file?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is an indexing strategy?
What is the difference between substr and charindex in the sql server?
What are functions in the sql server?
What are sql server functions?
What do you understand by a view?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
what is a transaction? : Sql server database administration
How to store and query spatial data?
Explain Reporting Life Cycle?