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

What is analyze command used for?

588

Explain the dml?

606

How to connect to the server with user account: sys?

570

How do you tell what your machine name is and what is its IP address?

1524

How to increment dates by 1 in oracle?

568

How to invoke the original export import utilities?

515

How to use "while" statements in oracle?

746

What is a data dictionary and how can it be created?

626

How to set up autotrace for a user account?

604

Explain the truncate in oracle?

558

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

558

How do I manually create a database in oracle?

552

What is a read write transaction in oracle?

616

How to define a sub function?

679

How do you bind variables in oracle?

559