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

How do I connect to oracle?

1035

What is the maximum limit on the number of columns in a table?

1089

How to loop through a cursor variable?

1092

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2351

What are the oracle differences between nvl and coalesce

1150

Why is oracle so popular?

1005

What is oracle server autotrace in oracle?

1167

What are the various constraints used in oracle?

1048

20. Using a set operator, display the client number of all clients who have never placed an order.

2193

How to install oracle database 10g xe?

1024

What are privileges and grants?

1068

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1121

What is private procedure oracle?

1015

What is execute immediate in oracle?

1023

What happens in oracle commit?

1033