select * from emp a where &n=(select count(b.sal) from emp b where b.

find out the third highest salary?

Question Posted / hanumantha r challa

Answer Posted / hanumantha r challa

select * from emp a where &n=(select count(b.sal) from emp
b where b.sal>=a.sal);

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Respected sir, Please send me technical questions related to oracle apps..

1377

What happens in oracle commit?

566

How can we delete duplicate rows in a table?

562

How can Oracle users be audited?

601

what are bitmap indexes? How does they work?

1716

Explain what are clusters?

612

How to do paging with oracle?

572

How to use null as conditions in oracle?

581

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1701

What do you mean by a deadlock?

515

What is the use of oracle?

550

What is the difference between PFILE and SPFILE in Oracle?

576

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

1951

What are advantages of dateset in datastage?

1744

What is a partition in oracle?

545