Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 23670 Views
- I also Faced
- E-Mail Answers
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
How to create a ddl trigger using "create trigger" statements?
Why main is user defined function?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is dbcc? Give few examples.
How to connect to SQL Azure Database by using sqlcmd?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What are the recovery models for a database?
What are the restraints imposed on the table design by a merge replication?
How to get the definition of a view out of the sql server?
how to create a scrollable cursor with the scroll option? : Sql server database administration
explain different types of backups avaialabe in sql server? : Sql server database administration
What is row_number function?
How do I find the size of a sql server database?
what happens on checkpoint? : Sql server database administration
what is a self join? : Sql server database administration
