select max(sal) from new where sal not in(select max(sal) from new);

how to get second highest salary in SQL(as/4000

Question Posted / chandu

Answer Posted / chandu

select max(sal) from new where sal not in(select max(sal)
from new);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What steps server process has to take to execute an update statement?

973

Can we join two tables without common column?

999

What is the difference between in and between in sql?

1055

Are sql database names case sensitive?

1000

Can one improve the performance of sql*loader? : aql loader

1046

what are date and time data types in mysql? : Sql dba

966

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

963

what is heap table? : Sql dba

1103

How to change the order of columns in Oracle SQL Plus ?

1054

How to add new employee details in an employee_details table with the following details

1088

What are different clauses used in sql?

1112

How many sql statements are used? Define them.

1035

Explain unique key in sql.

1004

What does count (*) mean in sql?

1579

What is record data type?

909