select empno,ename,sal from (select empno,ename,sal from emp order by sal

find out the third highest salary?

Question Posted / husenaiah.b

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

Answer Posted / husenaiah.b

select empno,ename,sal from
(select empno,ename,sal from emp order by sal desc)
group by rownum,ename,sal having rownum=&n;
from this query we can find top nth sal

Is This Answer Correct ?

22 Yes

38 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is Single Byte Overhead...?

2060

How do I spool to a csv formatted file using sqlplus?

548

What is a initialization parameter file in oracle?

584

How to create a new table in your schema?

605

What are the numeric comparison operations?

631

Please explain joins in oracle?

547

Â How to use an oracle sequence generator in a mapping?

570

State any two functions of oracle?

634

How do I connect to oracle?

562

How to drop a stored procedure in oracle?

590

What are the uses of synonyms?

603

What is oracle update statement with inner join ?

580

How to call a stored function in oracle?

572

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1646

What is blob data type in oracle?

559