SELECT max(salary) FROM Employee WHERE salary NOT IN (SELECT max(salary)

find out the second highest salary?

Question Posted / mahendra

Answer Posted / mahendra

SELECT max(salary) FROM Employee WHERE salary NOT IN
(SELECT max(salary) FROM Employee);

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is java oracle used for?

1075

What is oracle used for?

1069

What is a Garbage Collection? and what is full recursive Garbage collection?

2955

How can we force the database to use the user specified rollback segment?

1199

Does facebook use oracle?

1081

what is reindexing?

1729

How can we find out the duplicate values in an oracle table?

1118

What are the common oracle dba tasks?

1201

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1930

State some uses of redo log files?

1064

Which is better Oracle or MS SQL? Why?

6482

How to create a stored procedure in oracle?

1150

What is connection pool in oracle?

1036

is there a tool to trace queries, like profiler for sql server?

1196

What is procedure overloading in oracle?

1113