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

how to find nth highest salary

Question Posted / satesh naidu

Answer Posted / satesh naidu

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

Hai friends try this.u will get nth highest salary.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I install only the client tools of sql server 2000?

1073

What method is used by the Command classes to execute SQL statements that return single values?

1079

What are the different types of cursor?

1101

Does the unique constraint create an index?

1069

What are built in functions?

1029

Explain the steps needed to create a scheduled job?

944

if no size is defined while creating the database, what size will the database have? : Sql server administration

1017

Is sql server is free?

986

What is data modification?

982

What do you mean by acid?

1012

What are the built in functions in sql server?

992

How to define the name and server for a new dsn?

1128

Which are the third-party tools used in sql server and why would you use them?

916

What are the different types of backups avaialabe in sql server 2005?

1026

Can you type more than one query in the query editor screen at the same time?

1015