select sal, rownum from (select sal from table order by sal desc)

How to Select second Maximum salary in a Table ?

Question Posted / sephali

Answer Posted / sephali

select sal, rownum
from (select sal from table
order by sal desc)
where rownum=2

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is redo log?

1071

In oracle there is column command, how will you explain that?

1061

How to create a new view in oracle?

1080

What do you understand by database schema and what does it hold?

1233

What is Data Dictionary Cache in Oracle?

1169

What is a table index in oracle?

1132

How is it different from a normal table?

1039

What is backup in Oracle?

1008

How to view existing locks on the database?

1057

How to list all indexes in your schema?

1097

How to handle a single quote in oracle sql?

1058

What is system tablespace?

1103

What happens to the indexes if a table is recovered?

993

Explain integrity constraints?

1109

How to create a stored procedure in oracle?

1107