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

Does order by actually change the order of the data in the tables or does it just change the output?

1205

What are xml indexes?

1004

What is the use of stored procedure?

981

Do you know what are different types of replication in sql server?

1155

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

What is normalization of database? What are its benefits?

1071

How to replace the Query Result 'Null Value' with a text ?

1095

What is a covering index?

1043

What is set nocount on?

994

What is the difference between createstatement and preparedstatement?

1000

How do I find the transaction log size in sql server?

1004

What is a collation?

1132

How you can add messages to the nt event log from within a stored procedure?

1137

Does the order of columns in update statements matter?

956

What is 2nf example?

1054