SELECT * FROM Emp e1 WHERE (2) = ( SELECT COUNT(DISTINCT(e2.Salary)) FR

find out the third highest salary?

Question Posted / bhagayraj

Answer Posted / bhagayraj

SELECT *
FROM Emp e1
WHERE (2) = (
SELECT COUNT(DISTINCT(e2.Salary))
FROM Emp e2
WHERE e2.Salary > e1.Salary)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to call a stored function with parameters?

1045

Explain the use of indexes option in exp command.

1149

Can I create users through internet explorer in oracle 10g?

1084

How to use null as conditions in oracle?

1084

Can objects of the same schema reside in different tablespace?

1062

How can we force the database to use the user specified rollback segment?

1148

How can we find out the current date and time in oracle?

1088

What do you understand by a database object? Can you list a few of them?

1018

What privilege is needed for a user to delete rows from tables in another schema?

1067

What are the differences between char and varchar2 in oracle?

1170

How to connect to the server with user account: sys?

1019

How can you merge two tables in oracle?

1001

Explain the use of Merge statement in oracle 11g

1027

How do I find my oracle client driver version?

1040

what is Single Byte Overhead...?

2555