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 is a rank in sql?

897

What do you mean by field in sql?

1033

Do we need commit after truncate?

1026

what are all different types of collation sensitivity? : Sql dba

927

Can we commit in trigger?

920

Does sqlite need a server?

991

what is data integrity? : Sql dba

985

What is a native sql query?

969

How do you take the union of two tables in sql?

931

How show all rows in sql?

973

How do you go back in sql?

939

How do I count duplicates in sql?

1024

How much does sql certification cost?

1014

What is a crud api?

899

What are the steps for performance tuning.

1267