select max(sal) from emp where sal < select max (sal)from emp

find out the second highest salary?

Question Posted / mallikarjun

Answer Posted / mallikarjun

select max(sal) from emp
where sal < select max (sal)from emp

Mallikarjun

Is This Answer Correct ?

216 Yes

86 No

Please Help Members By Posting Answers For Below Questions

What are the major difference between truncate and delete?

988

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2309

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1670

How to create a new table by selecting rows from another table?

1023

State some uses of redo log files?

947

Explain the use of compress option in exp command.

969

How to add a new column to an existing table in oracle?

1074

How to connect to oracle using service name instead of sid?

964

What happens if you set the sga too low in oracle?

1057

What is control file used for?

1102

Hi Can any one tell me what are the API's used in requisition import.

1885

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1939

How many categories of data types in oracle?

963

State any two functions of oracle?

986

What are the differences between date and timestamp in oracle?

976