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

Explain sql delete command?

1091

How to provide login information for a new odbc dsn?

1094

What are “unrepeatable reads”?

1298

What is hot add cpu in sql server 2008?

983

What is join query?

938

How to list all columns in a table using odbc_columns()?

1032

What is TDS(Tabular Data Stream) Gateway?

127

Is it possible to update the views? If yes, how, if not, why?

1082

What is an entity-relationship diagram (erd)?

1310

How will you know when statistics on a table are obsolete?

1129

New concepts of sql server 2005 use in your project.

2401

How to write a query with a right outer join in ms sql server?

961

What is the tcp/ip port on which sql server runs?

1237

Explain transaction server auto commit?

1090

Do you know what are the steps to process a single select statement?

1018