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 does over partition by mean in sql?

1045

What are dml commands?

1076

What are the types of optimization?

1009

what is a cursor? : Sql dba

1066

Can we insert data in view?

1011

How many tables can a sql database have?

1029

How much does sql certification cost?

1142

Does truncate need commit?

1005

Which is better trigger or stored procedure?

1016

What is the best sql course?

1028

What is difference between hql and sql?

1166

What is the least restrictive isolation level? : Transact sql

1107

What is primary key secondary key alternate key candidate key?

1088

what is msql? : Sql dba

1044

What are the advantages of sql? Explain

1156