Select max(sal) From Employee where sal not in ( Select max (sal) From Emp

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

Question Posted / satheeshkumar

Answer Posted / satheeshkumar

Select max(sal) From Employee where sal not in ( Select max
(sal) From Employee)

Is This Answer Correct ?

24 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is java sql drivermanager?

1043

What's the difference between a primary key and a clustered index?

960

What is secondary key?

896

can a stored procedure call itself or recursive stored procedure? : Sql dba

973

Can there be 2 primary keys in a table?

967

Can function return multiple values in sql?

1000

What is your daily office routine?

2231

Show how functions and procedures are called in a pl/sql block.

1068

What is rollback?

1062

what is view? : Sql dba

921

Why stored procedures are faster than query?

991

What is number function in sql?

930

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

948

What is audit logout in sql profiler?

992

what are ddl statements in mysql? : Sql dba

1136