select top 1 * from emp where sal not in (select max(sal) from emp) order

how to find the second highest salary from emp table?

Question Posted / sunil

Answer Posted / sunil

select top 1 * from emp where sal not in (select max(sal)
from emp) order by sal desc

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How is sql used in oracle?

1015

Why use subqueries instead of joins?

1087

In what condition is it good to disable a trigger?

1024

What is sql key?

999

Does sqlite need a server?

1059

What is a clob in sql?

1027

Why select is used in sql?

1026

differentiate between float and double. : Sql dba

1065

Which sql most popular?

994

What is a data definition language?

1146

What is foreign key and example?

942

What do you mean by field in sql?

1088

What is a loop in sql?

992

Does pdo prevent sql injection?

935

What is difference between my sql and sql?

1082