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

how to get second highest salary in SQL(as/4000

Question Posted / premchand

Answer Posted / premchand

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

Is This Answer Correct ?

34 Yes

12 No

Please Help Members By Posting Answers For Below Questions

Which one is better subquery or joins?

775

What is range partitioning?

692

What is sql used for?

856

How do you go back in sql?

701

What is view? Can we update view

1081

Are there any features that are decommissioned in 11g that are not present in 11g?

1820

Why do we need a foreign key?

757

What do you understand by case manipulation functions?

733

Is progress software supports to ( pl/sql )?

718

What is the maximum size of sqlite database?

726

Determine if oracle date is on a weekend?

767

Why we use pl sql?

710

What is the need of merge statement?

764

Can a procedure in a package be overloaded?

754

Which sql statement is used to delete data from a database?

651