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 to export your connection information to a file?

1176

How to assign values to variables?

1163

What are the uses of synonyms?

1185

How can we find out the current date and time in oracle?

1131

How to assign data of the deleted row to variables?

1115

What is blob data type in oracle?

1207

Can multiple columns be used in group by in oracle?

1037

Explain oracle left join with an example?

1063

How do I recompile a procedure in oracle?

1018

What is an external table?

1081

What is the usage of save points in oracle database?

1012

What is the data type of dual table?

1065

Explain about the analyze command in oracle?

1112

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2250

What is Trigger in Oracle?

1241