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

What is a trace file and how is it created in oracle?

1147

What is the difference between sharding and partitioning?

1041

Explain what are the advantages of views?

1108

What is a select query statement in oracle?

1030

Explain about your project and its relation to the current job position you are applying to?

1078

Can we create trigger on materialized view in oracle?

1045

What are the database administrators utilities available?

1096

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4685

How to define a data source name (dsn) in odbc manager?

1084

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

1104

Is postgres faster than oracle?

1087

How to retrieve data from an cursor to a record?

1158

How to use null as conditions in oracle?

1127

what is difference between sql plus and sql*plus? (not sql and sql plus).

3943

What is the difference between substr & instr functions?

1295