Select max(sal) from employee where sal not in(select max (sal) from emplo

how to find the second highest salary from emp table?

Question Posted / surya

Answer Posted / surya

Select max(sal) from employee where sal not in(select max
(sal) from employee)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is pl sql a scripting language?

1037

how many sql ddl commands are supported by 'mysql'? : Sql dba

1030

What is sharding in sql?

994

What is sql procedures and functions?

1015

What are the types of subqueries?

1060

What are the different tcl commands in sql?

1185

What does cursor do in sql?

1034

What are sql triggers used for?

1004

Is primary key a clustered index?

975

Which is faster subquery or join?

1229

What does the base_object_type column shows in the user.triggers data dictionary view?

1057

What is a behavioral trigger?

983

What is the difference between pl and sql?

1099

What are the operators used in select statements?

1063

How to create an array in pl/sql?

1079