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 to take user input in pl sql?

1207

How to load data with sql*loader?

1112

Will truncate release space?

992

What is the max nvarchar size?

1031

what are the t string functions available in tsql? : Transact sql

1065

What is dbo in sql?

1020

what is top in tsql? : Transact sql

1171

Is it possible to link two groups inside a cross products after the cross products group has been created?

1072

What is a primary key called that is made up of more than one field?

1393

Does oracle roll back the transaction on an error?

1069

What is procedure function?

1126

Is sql a backend?

1073

What is a file delimiter?

1165

What is the use of prepared statement?

1076

Difference between truncate, delete and drop commands?

1145