SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT DISTINCT TOP 6 S

How to find 6th highest salary from Employee table ?

Question Posted / krishan kant

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

Please Help Members By Posting Answers For Below Questions

What is master database? : SQL Server Architecture

1082

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1010

What is a cache in ssrs?

138

How to run sql server 2005 books online on your local system?

1000

How do I view a stored procedure in sql server query?

979

What is nonclustered index with included columns ?

1015

Do you know clustered and non-clustered index?

1021

How to delete exactly duplicate records from a table?

1110

Can we shrink data file in sql server?

1092

What is SQL Azure Federations?

114

How to connect sql server management studio express to sql server 2005 express?

1102

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1267

Explain in details security in SQL azure?

123

How to disconnect from a sql server using mssql_close()?

1168

Differentiate between ms sql server reporting services vs crystal reports?

947