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 Collation Sensitivity ? What are the various type ?

955

How to handle bulk data?

1318

What is compiled query?

1042

What is group by in sql?

1089

What is a data definition language?

1144

which types of join is used in sql widely? : Sql dba

986

How do you pronounce sql?

1020

What is a database? Explain

1116

Is nosql relational?

947

What are the advantages of sql? Explain

1109

Which one is better sql or oracle?

975

How is a PL/SQL code compiled?

1240

how to show all tables with 'mysql'? : Sql dba

1121

What is a memo field?

972

What is vector point function?

1057