select * from empdetails where sal=(select max(sal) from empdetails where

find out the second highest salary?

Question Posted / aravind

Answer Posted / aravind

select * from empdetails where sal=(select max(sal) from
empdetails where sal<(select max(sal)from empdetails));

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

State and explain about oracle instance?

547

What types of joins are used in writing subqueries?

563

How do I uninstall oracle client from windows?

534

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

1747

how to join query for one source type is oracle another source type is sql server ?

1989

Can group functions be mixed with non-group selection fields?

530

What is an oracle tablespace?

604

Explain a synonym?

602

How does the on-delete-cascade statement work?

605

What are the original export and import utilities?

569

What is the purpose of tables, private synonyms and public synonyms in Oracle?

587

What do you mean by group by clause?

556

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1802

What privilege is needed for a user to delete rows from tables in another schema?

562

How can we find out the current date and time in oracle?

641