select * from emp where sal=(select MAX(sal) from emp where sal<

how to find the second highest salary from emp table?

Question Posted / manoj

Answer Posted / manoj

select * from emp
where
sal=(select MAX(sal) from emp
where
sal<(select MAX(sal)from emp))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is data control language (dcl)?

1135

what is schema? : Sql dba

1048

Is sql open source?

970

Is microsoft sql free?

1095

what is blob? : Sql dba

1145

How many databases can sql express handle?

982

what is sql? : Sql dba

1025

What is the use of non clustered index?

990

What is sql performance tuning?

917

What sql database should I use?

1139

What is the difference between truncate and drop statements?

1182

When is a declare statement required?

1138

Which table is left in left join?

1012

Is vs as in pl sql?

984

what is the use of set statement in tsql? : Transact sql

1009