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

Why schema is used in sql?

984

Which is better varchar or nvarchar?

933

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

976

Compare sql & pl/sql

1046

What is sql mysql pl sql oracle?

1026

What is the difference between instead of trigger and after trigger?

948

Show code of a cursor for loop.

1000

What is the difference between a query and a report?

901

Explain about various levels of constraint.

884

What is left join in sql?

1004

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1058

what is single byte over head in oracle..?

2340

How delete all records from table in sql?

928

What are the possible values for the boolean data field?

900

What is auto increment feature in sql?

1067