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 the different types of trigger and explain its various uses and functions?

1087

Is it possible to insert comments into sql statements return in the data model editor ?

2553

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

1046

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

2913

How to run the anonymous block again?

1129

Explain about the analyze command in oracle?

1049

What is a read write transaction in oracle?

1085

How to commit the current transaction in oracle?

1115

What are the attributes of the cursor?

1000

What is an oracle and why it is used?

1145

Explain the use of grant option in imp command.

1022

candidate key is subset of super key but not vice-verse explain

2068

What do you understand by a database object?

1055

how may join possible between (requisition with purchase order)

2243

How to compare dates in oracle sql?

1097