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

how to get second highest sal of emp table

Question Posted / yadunandan

Answer Posted / yadunandan

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

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to get execution path reports on query statements?

556

What are a collation and state the different types of collation sensitivity?

549

What are the parameters that we can pass through a stored procedure?

551

How to delete an existing row from a table in oracle?

641

How can I create database in oracle?

565

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1562

State some uses of redo log files?

554

6. Display the client name and order date for all orders using the traditional method.

1747

What is pragma autonomous transaction in oracle?

516

what is dynamic SGA and static SGA

3832

how to do daily transactions with out sql* loader control file regesterd in apps?

1219

What is a nvl function? How can it be used?

559

What are the restrictions in a oracle read only transaction?

566

Can multiple cursors being opened at the same time?

607

How to display row numbers with the records?

584