select max(sal) from new where sal not in(select max(sal) from new);

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

Question Posted / chandu

Answer Posted / chandu

select max(sal) from new where sal not in(select max(sal)
from new);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to get a list of columns in an existing table? : Sql dba

928

Can we use insert statement in function?

957

What is a constraint? Tell me about its various levels.

1101

how to drop an existing view in mysql? : Sql dba

1011

how mysql optimizes distinct? : Sql dba

1023

Is like operator in sql case sensitive?

978

What is meant by truncate in sql?

1023

What is the difference between alter trigger and drop trigger statements?

1061

Which is faster joins or subqueries?

943

Can we use two order by clause in query?

931

How do you truncate?

859

What is parameter substitution in sql?

993

What is identity column in sql server?

1001

What is trigger types of trigger?

1013

What's the procedure?

875