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

Why does for update in oracle 8 cause an ora-01002 error?

1055

Explain the use of rows option in imp command.

1145

How to lock and unlock a user account in oracle?

1166

What is a dynamic performance view in oracle?

1063

How to export your connection information to a file?

1182

Explain the use of file option in exp command.

1182

What is a tns file?

1054

11. Display the client number and name and the client number and name of the person who referred that client.

2398

How to select all columns of all rows from a table in oracle?

1107

What is PL/SQL ?

2235

How to create a stored function in oracle?

1167

what are actual and formal parameters?

1167

How to define a cusotmer as a supplier in ORACLE R12

2318

Where is the export dump file located?

1226

defination of bitmap index

2190