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

Explain the use of grant option in imp command.

1030

How to rename an index?

1071

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

1059

How to start your 10g xe server from command line?

1073

How to delete multiple rows from a table in oracle?

1060

How many types of auditing in Oracle?

1035

Compare and contrast between sql and sql server and explain its various functions?

964

How to drop a stored procedure in oracle?

1051

Explain the use of inctype option in exp command.

1034

Explain database link?

1123

How to convert characters to numbers in oracle?

1065

What is the purpose of save points in oracle database?

1118

Why oracle is used?

1058

How to write a query with a right outer join in oracle?

1169

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2341