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

How to find only %th Highest Sal

Question Posted / pavan

Answer Posted / pavan

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of sql?

1053

Can a view be mutating? If yes, then how?

1024

What is replication id?

933

what is clause? : Sql dba

1059

What is the difference between truncate and drop statements?

1176

Can we use insert statement in function?

996

Is sql dba a good career? : SQL DBA

983

What is union, minus and interact commands?

1285

what is view? : Sql dba

953

what is union? : Sql dba

1023

What are the benefits of pl/sql packages?

1105

What is sql character function?

1070

what is the difference between union and union all? : Sql dba

1016

what is timestamp in mysql? : Sql dba

1070

what are the authentication modes in sql server? : Sql dba

1060