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
5457 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 mrc ( multiple reporting currency)?

879

What is fsg? Explain its uses.

1000

What is user exits

822

what does 'unfreezing rollup groups' do?

945

How to register concurrent program with oracle apps?

883

What are cycles of gl, ap, and ar?

897

What is a token?

913

What is the menu?

888

Explain the uses of fsg?

890

What is a datalink?

1009

Define application top?

944

Is there any possibility for having custom schema at any time when it is required?

797

What is multi org architecture?

938

How to attain parameter value depending on the first parameter?

828

Explain the types of flexfields?

904