select max(sal) from salary where sal NOT IN (select max(sal) from salary)

how to get the second max val for every group in a table

Question Posted / indu

Answer Posted / indu

Is This Answer Correct ?

9 Yes

13 No

Please Help Members By Posting Answers For Below Questions

What happens in oracle commit?

1077

How to start your 10g xe server from command line?

1125

How do I find the database name in oracle?

1088

What to do if dba lost the system password?

1244

what is the dual table in oracle?

1038

What is the usage of save points in oracle database?

1011

How to lock and unlock a user account in oracle?

1160

How to insert multiple rows with one insert statement in oracle?

1134

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

1030

What is a proxy object?

1105

What is a select query statement in oracle?

1026

How to define an anonymous procedure without variables?

1191

What is a partition in oracle?

1204

Can we commit inside a function in oracle?

1012

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

1174