select max(sal) from emp where sal<(select max(sal) from emp)

i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table

Question Posted / mohan

Answer Posted / mohan

select max(sal) from emp where sal<(select max(sal) from
emp)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to turn on or off recycle bin for the instance?

1083

How will you write a query to get a 5th rank student from a table student_report?

1866

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2622

How can we delete duplicate rows in a table?

973

Are truncate and delete commands same? If so why?

1151

How to select an oracle system id (sid)?

1064

What are the differences between interval year to month and interval day to second?

1026

How to define a record variable to store a table row?

1058

How to create a table interactively?

1087

How to specify default values in insert statement using oracle?

1104

How to create lov dynamically at runtime & attach to text field?

1192

How to write a query with a left outer join in oracle?

1062

How to create a new table by selecting rows from another table?

1097

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

How many anonymous blocks can be defined?

1184