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 trigger types of trigger?

996

what are the differences among rownum, rank and dense_rank? : Sql dba

985

If a cursor is open, how can we find in a pl/sql block?

1105

what is primary key? : Sql dba

956

What is the non-clustered index in sql?

1011

how do you know if your mysql server is alive? : Sql dba

1027

give the syntax of grant and revoke commands? : Sql dba

1090

What is faster join or subquery?

962

Is sqlexception checked or unchecked?

920

How does postgresql compare to mysql?

989

Why we use sql profiler?

915

What are the different sql languages?

987

How do you identify a primary key?

1013

What is materialized view. What are different methods of refresh?

1332

How to return an array from java to pl/sql?

1063