select max(salary) from employee not exists (select max(salary)from employ

How to Select second Maximum salary in a Table ?

Question Posted / ranjini

Answer Posted / ranjini

select max(salary) from employee not exists (select
max(salary)from employee)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to use windows user to connect to the server?

956

How do I start tns listener?

1000

What is the relation of a user account and a schema?

1075

What is transaction control statement and how many types of transaction control statement in Oracle?

1102

How to use "while" statements in oracle?

1258

What is the relationship among database, tablespace and data file?

946

What is the difference between postgresql and oracle?

998

What are the four Oracle system processes that must always be up and running for the database to be useable?

971

Explain the use of record length option in exp command.

1040

What is the recommended interval at which to run statspack snapshots, and why?

2886

How to select some columns from a table in oracle?

1024

Explain how are indexes update?

1039

How to check the server version in oracle?

1060

How many memory layers are in the oracle shared pool?

1130

How to select all columns of all rows from a table in oracle?

1016