select max(sal) from emp where sal<>(select max(sal) from emp);

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / jebitha

Answer Posted / jebitha

select max(sal) from emp where sal<>(select max(sal) from
emp);

Is This Answer Correct ?

7 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Explain raise_application_error.

1044

What does joining a thread mean?

975

What is sql injection vulnerability?

872

How do you clear the screen in sql?

1012

Can we create index on primary key?

916

What are the rules to be applied to nulls whilst doing comparisons?

1274

what is the difference between char_length and length? : Sql dba

993

what are the join types in tsql? : Transact sql

983

What are the different operators available in sql?

963

What is sql constant?

945

What is the process of debugging?

1006

What is the difference between an inner and outer join?

963

what are the properties and different types of sub-queries? : Sql dba

969

What is error ora-12154: tns:could not resolve the connect identifier specified?

1018

Why we use cross join?

890