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 tuples in sql?

778

what are the 'mysql' command line options? : Sql dba

741

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

781

What is string join?

746

What is the difference between clustered and non-clustered indexes?

798

Can a select statement fire a trigger?

887

Mention what problem one might face while writing log information to a data-base table in pl/sql?

871

How many triggers can be applied to a table?

779

What is the cause of mutating table error and how can we solve it?

784

Is primary key always clustered index?

733

Explain the difference between 'between' & 'and' operators in sql

722

What is the use of count (*) in sql?

754

What is coalesce in sql?

732

Can we call procedure in select statement?

732

What is a field in a database?

760