select max(sal) from emp where sal <(select max (sal)from emp);

find out the second highest salary?

Question Posted / karthikeyan

Answer Posted / karthikeyan

select max(sal) from emp
where sal <(select max (sal)from emp);

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Is truncate autocommit in oracle?

1025

What are the uses of linked server and explain it in detail?

1004

How to shutdown your 10g xe server?

1084

What is SQL access advisor in Oracle?

1138

What are the differences between primary key and unique key?

949

What do you mean by cdb and pdb in oracle 12c?

1008

How to rename an index?

997

Why is oracle database so popular?

949

How to write text literals in oracle?

1021

In what script is snap$ created? In what script is the scott/tiger schema created?

2656

what is Single Byte Overhead...?

2500

What is parameterized cursor in oracle?

1068

Name the various constraints used in oracle?

971

What is the difference between pre-select and pre-query?

1125

What is the simplest tool to run commands on oracle servers?

957