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 is the maximum limit on the number of columns in a table?

1089

What is dynamic proxy?

1011

Explain how you would restore a database using RMAN to Point in Time?

2146

Why do we need integrity constraints in a database?

1023

What is a static data dictionary in oracle?

1115

What are the limitations of check constraint?

1033

State the various uses of dbcc command?

1060

What is BBED in Oracle?

1157

How to view existing locks on the database?

1054

What is truncate oracle?

975

Explain constraining triggers.

1101

What is the dynamic sql in oracle?

1078

How to check the server version in oracle?

1094

How can I introduce multiple conditions in like operator?

990

What is the sql query to concatenate column values from multiple rows in oracle?

1062