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

How to define a data field as not null?

1061

Explain the use of inctype option in exp command.

978

What is columnar storage what is the advantage?

988

What are the different types of synonyms?

1078

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2332

How to shutdown your 10g xe server?

1088

Define oracle database

993

How to handle a single quote in oracle sql?

975

How to apply filtering criteria at group level in oracle?

987

Explain constraining triggers.

1045

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

1018

What is the difference between view and materialized view in Oracle?

1095

How to create a testing table in oracle?

948

What is the fastest query method to fetch data from the table?

1297

How to create a table index?

1064