select sal from emp where sal = (select sal from (select distinct sal

find out the third highest salary?

Question Posted / ruchira

92 Answers
147746 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

Answer Posted / ruchira

select sal from emp
where sal =
(select sal from
(select distinct sal from emp OrderBy sal desc)
[table alias] where rownum < 4 )

Is This Answer Correct ?

1 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain enable novalidate constraint.

1035

What is an oracle tablespace?

985

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1871

Is a rollback possible to any savepoint?

1002

What are the original export and import utilities?

1058

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2046

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

999

How to synchronize 2 schema's objects?

2117

What are the differences between blob and clob in oracle?

1033

What is a trigger oracle?

1039

How to use subqueries in the from clause in oracle?

1046

What is a read write transaction in oracle?

1032

Explain the use of Merge statement in oracle 11g

978

Explain coalesce function?

1119

How to use "in" parameter properly?

1006