select max(salary) from users where salary not in (select max(salary) from

find out the second highest salary?

Question Posted / new

Answer Posted / new

select max(salary) from users where salary not in (select max(salary) from users)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to run create database statement again?

618

How to install oracle odbc drivers?

623

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1672

What is recovery manager in Oracle?

589

How to check your oracle database 10g xe installation?

579

How to delete multiple rows from a table in oracle?

563

Explain the dml?

592

What is blob datatype?

569

How to write an inner join with the where clause in oracle?

583

What is oracle database client?

553

How do I uninstall oracle 11g?

557

Can we use bind variables in oracle stored procedure?

488

Does oracle partitioning improve performance?

550

How to change program global area (pga) in oracle?

582

What is max rowid in oracle?

551