select * from Employee e1 where 6=(select count(distinct(salary))from empl

How to find 6th highest salary from Employee table ?

Question Posted / maheswar reddy s

Answer Posted / maheswar reddy s

select * from Employee e1 where 6=(select count(distinct(salary))from employee e2 where
e2.salary>=e1.salary)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is it possible to call a stored procedure within a stored procedure?

913

How to choose all records from the table?

997

Is the order of columns in the set clause important in ms sql server?

925

What is the default fill factor value?

1010

What are the difference between “where” and “having” clause in sql server?

1002

Explain sql delete command?

1002

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1095

What is a user-defined function in the sql server and what is its advantage?

1043

what stored procedure can you use to display the current processes? : Sql server administration

957

What are different types of join?

1233

What are the source of constraints?

857

Do you know the capabilities of cursors?

1074

What is a raid and what are different types of raid configurations?

1201

How to backup SQL Server Reporting Services ?

137

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

109