To get nth highest salary from Employee table: select * from Employee e wh

how to find nth highest salary

Question Posted / lakshmi reddy

Answer Posted / lakshmi reddy

To get nth highest salary from Employee table:
select * from Employee e where n=(select COUNT(distinct sal)
from Employee e2 where e2.Sal>e.Sal)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what are constraints? Explain different types of constraints? : Sql server database administration

1050

What is a coalesce function?

1254

What is the difference between TRUNCATE and DROP?

1192

How to link tables in sql server?

976

How to start and end transact-sql statements?

1090

do you know how to configure db2 side of the application? : Sql server database administration

1101

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

997

What is local temp table?

1024

What is the difference between varchar and nvarchar datatypes?

1142

Are semicolons required at the end of sql statements in sql server 2005?

1038

Why transaction is important?

1023

What is faster join or union?

1320

Can sql servers link to other servers like oracle?

896

Explain difference between cross join and full outer join?

1068

What are truncate options available in sql server? : sql server database administration

1086