SQL> select max(sal) from emp where sal<(select max(sal) from emp);

find out the second highest salary?

Question Posted / prasant

Answer Posted / prasant

SQL> select max(sal) from emp where sal<(select max(sal)
from emp);

MAX(SAL)
----------
3000

Is This Answer Correct ?

22 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is an oracle user role?

939

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1047

Explain about the analyze command in oracle?

998

How to execute a stored procedure in oracle?

1030

Where is the export dump file located?

1082

Explain what are the advantages of views?

1014

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1846

How to use attributes of the implicit cursor in oracle?

951

How to sort output in descending order in oracle?

989

What are the predefined tablespaces in a database?

1011

can u plz provide me oca sql dumps please i need them

1900

How does oracle handle read consistency?

1052

What privilege is needed for a user to create indexes in oracle?

965

How to define an oracle sub procedure?

1058

if you ctreate table identity

2316