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

how to get second highest sal of emp table

Question Posted / manjeet

Answer Posted / manjeet

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is SQL Tuning Advisor in Oracle?

1109

How to drop an index?

910

Explain oracle 12c new features for developers?

995

What is the difference between formal parameters and actual parameters?

1005

What are temporal data types in oracle?

1066

What are the tools for Oracle ?

1009

What are the predefined tablespaces in a database?

1011

How do I manually uninstall oracle client?

1025

How oracle handles dead locks?

1021

Define oracle database

993

What is oracle analytical function?

1032

What is an oracle tablespace?

985

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2064

How to install oracle database 10g xe?

967

How to call a sub procedure?

1036