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 privilege is needed for a user to insert rows to tables in another schema?

1015

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2209

How many types of table in Oracle?

1128

definition of cluster and non-clustered index?

3035

What is the best way to do multi-row insert in oracle?

1067

How to invoke the data pump import utility?

1169

What are the original export and import utilities?

1175

Explain compound trigger in oracle?

1045

Why is oracle database so popular?

1007

How do I connect to oracle?

1032

Explain about functional dependency and its relation with table design?

1013

Difference between cartesian join and cross join?

1050

what's query optimization and without use of IN AND Exist can we get another way data from query

2144

What are the extensions used by oracle reports?

1039

What are the logical operations?

1126