Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 23671 Views
- I also Faced
- E-Mail Answers
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 are different types of raid configurations? : SQL Server Architecture
What is query cost in sql server?
What is named calculation? : sql server analysis services, ssas
What are the different types of replication you can set up in sql server?
How to apply filtering criteria at group level with the having clause in ms sql server?
Explain database normalization?
State a few properties of relational databases?
Can primary key be null?
What are the types of joins in sql?
How to provide column names in insert statements in ms sql server?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is difference between index seek vs. Index scan?
What are the new features in sql server 2016?
How many database files are there in sql server 2000?what are they?
Write a query to find 5th highest amount paid from the customer table.
