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

Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...

Question Posted / raj

Answer Posted / raj

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

Is This Answer Correct ?

31 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a nested table and how is it different from a normal table?

988

What is data file?

1046

How can Oracle users be audited?

1056

How to check the oracle tns settings?

992

How can I introduce multiple conditions in like operator?

926

What is a database table in oracle?

954

Explain mutating triggers.

974

What is the use of file param in imp command?

1117

What is an oracle database?

991

Why do we use coalesce function in oracle?

1053

What is oracle datasource?

926

What are the restrictions on external table columns?

995

What is key preserved table?

961

What is oracle update statement with inner join ?

995

What is execute immediate in oracle?

951