select max(sal) from emp where sal not in (select max(sal) from emp )

how to find the second highest salary from emp table?

Question Posted / winnie

Answer Posted / winnie

select max(sal) from emp
where sal not in (select max(sal) from emp )

Is This Answer Correct ?

1090 Yes

131 No

Please Help Members By Posting Answers For Below Questions

Can you call pl/sql package functions from within a fast formula?

993

can a stored procedure call itself or recursive stored procedure? : Sql dba

974

How do I upgrade sql?

972

How do I order by ascending in sql?

979

How to order siblings in oracle hierarchy queries?

1005

How do you optimize a stored procedure query?

965

Does view contain data?

995

where are cookies actually stored on the hard disk? : Sql dba

996

how to include numeric values in sql statements? : Sql dba

1065

What is a schema? How is it useful in sql servers?

1062

How do sql databases work?

967

Why should I use postgresql?

990

Which command is used to call a stored procedure?

974

Is it possible to create startup or shutdown trigger for on-schema?

1000

what are integrity rules?

986