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

How do you clear the screen in sql?

1076

Can you inner join the same table?

995

How does postgresql compare to mysql?

1039

Can we update views in sql?

942

How many types of sql are there?

987

What does 0 mean in sql?

969

What is trigger types of trigger?

1073

What is a database? Explain

1116

explain commit and rollback in mysql : sql dba

1023

What are predefined functions in sql?

1049

What is the difference between the implicit and explicit cursors?

1054

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1068

What is a nested table in word?

962

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1045

What is nosql example?

1038