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 is the difference between "as" and "is" in an oracle stored procedure?

931

What is the sid in oracle?

898

Is postgres faster than oracle?

969

How will you differentiate between varchar & varchar2?

990

What is flashback in Oracle?

963

Explain an extent?

1048

How do I escape a reserved word in oracle?

1130

defination of bitmap index

2044

How to experiment a data lock in oracle?

998

How to use "out" parameter properly?

1022

How can we create the complete backup of data in the oracle.

2091

Explain do view contain data?

940

How to use "startup" command to start default instance?

962

What is sharded cluster?

924

How to compare dates in oracle sql?

1040