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

find out the second highest salary?

Question Posted / karthikeyan

Answer Posted / karthikeyan

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

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the best way to do multi-row insert in oracle?

569

How many types of tables supported by oracle?

592

What are internal user account in oracle?

578

When do you get a .pll extension in oracle?

684

What is oracle and what are its different editions?

587

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

1696

Why is oracle used?

563

How do I start tns listener?

553

What are the different types of trigger and explain its various uses and functions?

557

What is the exact use of Collections?

1696

How to get last row id?

567

what is dynamic SGA and static SGA

3854

How to define a data field as not null?

640

How to use "out" parameter properly?

640

What is instant client oracle?

550