select sal from table where rownum = 2 order by sal desc

How to Select second Maximum salary in a Table ?

Question Posted / havyas

Answer Posted / havyas

Is This Answer Correct ?

1 Yes

13 No

Please Help Members By Posting Answers For Below Questions

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1911

What is partitioned table in Oracle?

1189

What are the different types of synonyms?

1140

what is insert all statement in sql

6515

Difference between cartesian join and cross join?

1039

What is a dead lock in oracle?

1122

How to shutdown your 10g xe server?

1149

Can we store images in oracle database?

1009

what is the scenario where you take the database to NoArchivelog mode?

2331

What are the numeric comparison operations?

1111

What do you mean by merge in oracle and how can you merge two tables?

948

Is it possible to split the print reviewer into more than one region ?

2280

What are oracle functions?

1030

Explain the use of rows option in exp command.

1091

Is oracle a programming language?

985