select max(sal) from emp where sal not in (select top2 sal from emp order b

How to Select second Maximum salary in a Table ?

Question Posted / kuldeep singh

Answer Posted / kuldeep singh

select max(sal) from emp where sal not in (select top2 sal from emp order by sal desc)

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to convert character types to numeric types?

1076

How to recover a dropped table in oracle?

1002

How to define an oracle sub procedure?

1084

What is set verify off in oracle?

1057

How to create an oracle database manually?

1045

Point the difference between translate and replace?

1045

What is the difference between online and offline backups?

1006

Is there a combination of "like" and "in" in sql?

1028

What is different types of joins?

989

Explain about achiever in sql?

992

What is oracle server autotrace in oracle?

1119

Is java required for oracle client?

941

does the query needs a hint to access a materialized view?

1832

Explain oracle’s system global area (sga).

1109

How to grant create session privilege to a user in oracle?

964