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

What is the main reason behind using an index?

964

How do I install microsoft sql?

977

Can we join two tables without common column?

928

Explain foreign key in sql?

968

What is nvarchar max in sql?

959

What view means?

927

what is a trigger in mysql? : Sql dba

1065

What is an inconsistent dependency?

977

What packages(if any) has oracle provided for use by developers?

5713

what are all different types of collation sensitivity? : Sql dba

927

What are the most important ddl statements in sql?

1024

How can we make an if statement within a select statement?

957

What is a join query?

905

What is a scalar value in sql?

1010

What is audit logout in sql profiler?

976