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

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2555

Explain the use of consistent option in exp command.

1068

What are the differences between number and binary_float in oracle?

1101

Explain a data segment?

1071

How can we find out the duplicate values in an oracle table?

1046

How to create a new table by selecting rows from another table?

1102

How to test null values?

1108

What are a collation and state the different types of collation sensitivity?

1171

Why do we need oracle client?

950

What is an oracle user role?

984

How to unlock the sample user account in oracle?

1018

What are the attributes that are found in a cursor?

1078

What is data block in Oracle?

1116

How to check database size in Oracle?

1191

What is a table index in oracle?

1131