SELECT COL1,COL2,ROWNUM FROM (SELECT COL1,COL2 FROM TABLE ORDER BY COL1 DE

select three highest values from a table.

Question Posted / rashmiraj

1 Answers
5383 Views
I also Faced
E-Mail Answers

Answer Posted / rashmiraj

SELECT COL1,COL2,ROWNUM
FROM (SELECT COL1,COL2 FROM TABLE ORDER BY COL1 DESC)
WHERE ROWNUM<=&A;

as for example........

select ename,job,sal,rownum
from (select ename,job,sal from emp order by sal desc)
where rownum <=3;

Is This Answer Correct ?

13 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define record group?

930

What is the firing sequence related with report triggers?

878

Explain the types of user exits?

798

What are cycles of ar?

833

Define fsg ( financial statement generator) ?

824

What is the usage of the spawned object?

925

How to register concurrent program with oracle apps?

847

How to enable tracing for document managers

791

How will you open a bc4j package in jdeveloper?

937

Define the steps for customizing form?

871

Explain the mechanisms to trace the document manager?

789

Define set – of books?

925

I want to setup additional organizations, do I have to setup multiorg?

800

What is flexfield?

836

Is there any documentation on how to setup an organization?

843