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 background process in Oracle?

1099

What is meant by an index?

1139

Is the After report trigger fired if the report execution fails ?

2913

What is an external table?

1014

How to write text literals in oracle?

1066

What does sharding mean?

997

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2142

What is execute immediate in oracle?

1017

How to check the oracle tns settings?

1045

How to create id with auto_increment on oracle?

986

interview questions with answer for cts

2578

What the is the diff between local index and global index. give some example.

1638

Why does oracle 9i treat an empty string as null?

1054

Is oracle the best database?

963

Can we use bind variables in oracle stored procedure?

948