select max(sal) from emp where sal not in(select max(sal) from emp);

find out the second highest salary?

Question Posted / hiten

Answer Posted / hiten

select max(sal) from emp where sal not in(select max(sal)
from emp);

Is This Answer Correct ?

25 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I learn what codesets are available in oracle?

659

Can select statements be used on views in oracle?

672

How to empty your oracle recycle bin?

647

How to filter out duplications in the returning rows using oracle?

723

How to convert numbers to characters in oracle?

658

Why do we use bulk collect in oracle?

665

Is there a function to split a string in plsql?

651

Can the query output be sorted by multiple columns in oracle?

646

What is the database name in oracle?

637

How do I uninstall oracle 11g?

641

What is oracle host variable?

618

How to install oracle database 10g xe?

645

Can we call procedure inside function in oracle?

687

What is logical backup in oracle?

644

How to start your 10g xe server?

687