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

Can we insert data into view?

903

What is the use of procedures?

975

What is a record in a database?

1062

What is dml statement?

956

how to use like conditions? : Sql dba

1110

What is lexical units in pl sql?

1146

Why self join is used in sql?

976

How many parts of a pl sql block are optional?

1134

Can we commit inside a trigger?

994

How to run sql statements through the web interface?

1041

Explain the difference between rename and alias?

1010

How exception is different from error?

1019

What is multiple partition?

967

Is it possible to update views?

959

What is rollback?

1115