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

Does inner join return duplicate rows?

974

How does postgresql compare to "nosql"?

1029

Can we use two order by clause in query?

967

Is postgresql a server?

1047

How do I save a stored procedure?

1004

what are the drivers in mysql? : Sql dba

1019

What is sharding in sql?

973

What are the advantages of indexing?

982

What are sql constraints?

1172

What is varchar used for?

1074

Is pl sql useful?

990

How can triggers be used for the table auditing?

1068

Can a select statement fire a trigger?

1154

How do I run a script in sql developer?

944

explain the difference between delete , truncate and drop commands? : Sql dba

1091