select level,max(sal) from emp where level=&levelno connect by prior s

how to findout the 100th maximum salary

Question Posted / maroju naveen

Answer Posted / maroju naveen

select level,max(sal) from emp where level=&levelno
connect by prior sal>sal
group by level;
This is Nth max(sal) query.....

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is trigger in sql? Explain

999

What is sqlcommand?

1032

what are the different functions in sorting an array? : Sql dba

1027

What is the non-clustered index in sql?

1064

Is it possible to read/write files to-and-from PL/SQL?

1104

What is cte sql?

1002

What is having clause in sql?

970

What is dialect in sql?

953

Is a secondary key the same as a foreign key?

1038

What is fmtonly in sql?

1088

How do you remove duplicate records from a table?

943

What is the difference between view and stored procedure?

959

What does t sql mean?

951

Explain spool.

1186

What are different types of functions in sql?

1006