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

What do you mean by merge in oracle?

996

How to get execution path reports on query statements?

987

How many types of segments in Oracle?

1070

How can I introduce multiple conditions in like operator?

989

what is Single Byte Overhead...?

2555

What happens if variable names collide with table/column names?

1191

What is the usage of save points in oracle database?

964

What are a cluster and non-cluster index?

1018

What are the different types of partitions in oracle?

977

How to drop an index in oracle?

1076

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

992

How to put more than 1000 values into an oracle in clause?

1029

How would you change old and new values in an insert, delete and update triggers?

1022

What is the data pump export utility?

1081

What is a proxy class?

1052