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

What makes a good primary key?

1093

Write a sql query to convert all character to uppercase after hypen.

1484

What are the different operators available in sql?

1057

How can you fetch common records from two tables?

1102

What is a sql profiler?

1064

How exception is different from error?

1065

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1108

how would you get the current date in mysql? : Sql dba

1015

What is the difference between the sql*loader and import utilities? : aql loader

1090

how to shutdown mysql server? : Sql dba

1144

What is anonymous block in sql?

1172

What is an emotional trigger?

1057

What is meant by truncate in sql?

1109

What is foreign key sql?

1039

What is primary key in db?

1069