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

How to combine two stored procedures in sql?

1326

Does oracle use sql?

992

What is the difference between rename and alias?

1390

What is sharding in sql?

1041

What is pl sql package?

1073

Can a table contain multiple foreign key’s?

1056

How do you use a while loop in pl sql?

1056

what is unique key constraint? : Sql dba

1099

What is flag in sql?

1099

What is secondary key?

989

Why is a primary key important?

1105

What is write ahead logging in sql server?

1101

Where can I learn sql for free?

1050

How to download oracle sql developer?

1167

Define union, minus, union all, intersect ?

1065