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

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

1020

What are ddl statements in oracle?

1075

What is a sub query? What are its various types?

1179

What is a trigger oracle?

1088

How to write an inner join with the where clause in oracle?

1044

What is java oracle used for?

1025

what is insert all statement in sql

6519

How to shutdown your 10g xe server?

1149

What is the usage of control file in oracle?

1090

What is SQL Tuning Advisor in Oracle?

1181

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

1046

What is pragma autonomous transaction in oracle?

1070

How to use values from other tables in update statements using oracle?

1080

What is coalesce function?

1074

What is bulk collect in oracle?

996