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

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2423

What happens to the indexes if a table is recovered?

1045

Which environment variables are absolutely critical in order to run the OUI?

2173

Differentiate between pre-select and pre-query?

1154

How to delete a user account in oracle?

1021

What are advantages of dateset in datastage?

2309

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2148

What is a read only transaction in oracle?

1079

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2234

How to check database size in Oracle?

1256

What are the different types of trigger and explain its various uses and functions?

1167

How do I manually create a database in oracle?

1069

List the various oracle database objects?

1111

What is instant client oracle?

1073

What are the limitations oracle database 10g xe?

1093