select min(sal) from (select sal from emp order by sal desc) where rownum&l

how to findout the 100th maximum salary

Question Posted / aswini

Answer Posted / aswini

select min(sal) from (select sal from emp order by sal desc) where rownum<=100

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is dcl in sql?

1024

What is dml statement?

999

What is the difference between null value, zero, and blank space?

1250

What does cursor do in sql?

1067

How do temporal tables work?

1018

Which kind of parameters cannot have a default value in pl sql?

1207

What are the different datatypes available in PL/SQL?

1145

Explain the components of sql?

1106

Can we create clustered index without primary key?

1000

what is a tablespace? : Sql dba

1100

What is an inconsistent dependency?

1082

How do I edit a trigger in sql developer?

1052

What is int identity in sql?

1202

What is union and union all keyword in sql and what are their differences?

1157

What pl/sql package consists of?

1133