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

what is sql profiler? : Sql dba

592

What is a unique key?

588

What are the main features of cursor?

631

How many commands are there in sql?

550

What is meant by truncate in sql?

526

What is trigger with example?

567

What program will open a mdb file?

503

What are the different sql commands?

521

What type of database is cloud sql?

579

what is 'mysqldump'? : Sql dba

573

What are the different types of database management systems?

532

What is graph sql?

528

What is package in pl sql?

579

What is a subquery in sql?

511

What is the command used to fetch the first 5 characters of a string?

710