In ORACLE 10g, SELECT * FROM employee x WHERE 3 = (SELECT COUNT(DISTINCT

find out the third highest salary?

Question Posted / selvaraj anna university coe

In ORACLE 10g,

SELECT * FROM employee x WHERE 3 = (SELECT COUNT(DISTINCT
salary)
FROM employee y WHERE x.salary <= y.salary);

Is This Answer Correct ?

16 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is query image?

921

Explain oracle instance.

1101

How to export your own schema?

964

Explain the use of analyse option in exp command.

1063

What is set verify off in oracle?

1026

ABOUT IDENTITY?

2002

Please explain oracle left join with an example?

955

How to commit the current transaction in oracle?

1041

How to start a new transaction in oracle?

1014

What is a trigger and what are its types?

1107

How to view all columns in an existing table?

869

what are the default admin accounts in Oracle 10g ?

916

Explain an index?

1087

Explain rename?

920

What is a trigger oracle?

1037