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 master database? : SQL Server Architecture
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is a cache in ssrs?
How to run sql server 2005 books online on your local system?
How do I view a stored procedure in sql server query?
What is nonclustered index with included columns ?
Do you know clustered and non-clustered index?
How to delete exactly duplicate records from a table?
Can we shrink data file in sql server?
What is SQL Azure Federations?
How to connect sql server management studio express to sql server 2005 express?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Explain in details security in SQL azure?
How to disconnect from a sql server using mssql_close()?
Differentiate between ms sql server reporting services vs crystal reports?