select * from emp where sal = ( select max(sal) from emp where level =

How to find only %th Highest Sal

Question Posted / ajit

Answer Posted / ajit

select *
from emp
where sal = ( select max(sal)
from emp
where level = &n
connect by prior sal > sal
group by level);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the uses of database trigger.

650

How do you update a sql procedure?

521

Why do we go for stored procedures?

507

How to display the records between two range in Oracle SQL Plus?

636

What are the different types of database management systems?

530

Is sql a scripting language?

513

what is the difference between char and varchar data types? : Sql dba

533

What is mdf ldf and ndf?

558

What is the difference between functions, procedures, and packages in pl/sql?

482

What is difference between stored procedures and application procedures?

567

What is user in sql?

575

how many groups of data types? : Sql dba

563

Can a foreign key be null?

586

What do you understand by exception handling in pl/sql?

575

What is a heap in sql?

526