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

how to find the second highest salary from emp table?

Question Posted / amarendra swain

Answer Posted / amarendra swain

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

What are the operators used in select statements?

1000

Why stored procedure is better than query?

885

what are null values? : Sql dba

900

How many types of normalization are there?

895

What are instead of triggers?

993

what is schema? : Sql dba

986

Is primary key is clustered index?

938

What does closing a cursor do?

1244

Is sql a microsoft product?

896

What is primary key secondary key alternate key candidate key?

980

What is a Mapplet?

1057

Can function return multiple values in sql?

985

how to get @@error and @@rowcount at the same time? : Sql dba

968

What is triggering circuit?

1016

What is query execution plan in sql?

1128