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

Difference between truncate, delete and drop commands?

1082

How many joins can you have in sql?

934

What is the purpose of a sql?

974

Explain mutating table error.

1200

write an sql query to find names of employee start with 'a'? : Sql dba

1024

Is sql similar to python?

969

What is record type in pl sql?

984

What are the two types of periodical indexes?

936

What is compiled query?

1035

What is compilation error in pl sql?

974

Is big data nosql?

942

What are triggers and its types?

1055

What is oracle sql called?

922

Cite the differences between execution of triggers and stored procedures?

1076

What is a temporal table?

927