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 sqlservr exe?

1028

What is the usage of distinct keyword?

1113

What is java sql connection?

1120

What is multiple partition?

1019

How do I view a table in sql?

1040

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1223

Can a varchar be a primary key?

1047

What are all the common sql functions?

1084

Explain the difference between drop and truncate commands in sql?

1108

How to run sql statements with oracle sql developer?

1121

How do you write a subquery?

1070

What is group function in sql?

1067

how to install mysql? : Sql dba

1156

Explain what is a view?

1115

what is the difference between inner and outer join? Explain with example. : Sql dba

1063