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

What is information schema in sql?

1075

What is the difference between the conventional and direct path loads? : aql loader

1401

what is uncommittable transactions? : Transact sql

997

What is the location of pre_defined_functions.

1166

What is sql engine in oracle?

994

What is the maximum database size for sql express?

1030

what are the different index configurations a table can have? : Sql dba

998

How to know the last executed procedure?

1100

What are the parts of a sql statement?

1090

Explain what is dbms?

1071

What is PL/SQL Records?

1197

what's the difference between a primary key and a unique key? : Sql dba

1053

Which sql statement is used to return only different values?

1008

How to connect a sql*plus session to an oracle server?

1129

How can get second highest salary in sql?

991