select e1.* from emp e1 where n=(select count(distinct(e2.sal)) from emp e

how to find nth highest salary

Question Posted / ramakrishna

Answer Posted / ramakrishna

select e1.* from emp e1 where n=(select
count(distinct(e2.sal)) from emp e2 where e1.sal<=e2.sal);

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can binary strings be converted into numeric or float data types?

1033

What do you understand by the analysis services in sql server?

939

What is sparse columns of sql server 2008?

1057

Explain the dbcc pintable command when would you use it?

920

Can I disable or restrict ssrs export formats (rendering formats)?

150

What are logical database components? : SQL Server Architecture

1035

What is BLOCK statements in SQL?

1263

What is equi join with example?

1130

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1932

on line cluster can we make if yes tell me the procedure

2023

What command would you use to create an index?

1056

Why we use functions in sql server?

1077

How to turn on the mssql api module in php?

1078

What is nonclustered index on computed columns?

960

How can I tell if sql server is 32 or 64 bit?

961