Here is the correct query: select ename,sal from emp e where 3 = (selec

find out the third highest salary?

Question Posted / vishal

Answer Posted / vishal

Here is the correct query:

select ename,sal from emp e
where 3 = (select count(distinct(sal))+1 from emp
where e.sal < sal);

Is This Answer Correct ?

12 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What are oracle functions?

1090

What are the arithmetic operations?

1152

How to display employee records who gets more salary than the average salary in the department?

1126

What is primefaces used for?

1098

Does oracle partitioning improve performance?

1053

What to do if the startbd.bat failed to start the xe instance?

1128

What are the different pseudo commands? Explain in general?

1125

What is materialized view in Oracle?

1116

How to load excel data sheet to oracle database

1078

How to start a new transaction in oracle?

1137

what is a Nested Loop join?

2175

why dont we assign not null constraint as table level constraint.

2798

What is the usage of synonyms?

1219

Difference between cartesian join and cross join?

1093

What is a nested table and how is it different from a normal table?

1112