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 blob datatype?

1059

What is the difference between count (*), count (expression), count (distinct expression)?

966

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1814

How to convert raw data type into text in oracle? Explain

953

How to sort the query output in oracle?

972

How to omit columns with default values in insert statement in oracle?

1003

How to apply filtering criteria at group level in oracle?

987

What is difference between cartesian join and cross join?

1020

what is the scenario where you take the database to NoArchivelog mode?

2259

Explain the use of indexes option in exp command.

1066

How can we force the database to use the user specified rollback segment?

1071

How would you begin to troubleshoot an ORA-3113 error?

2025

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

2245

11. Display the client number and name and the client number and name of the person who referred that client.

2278

what are actual and formal parameters?

1052