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
5437 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

Explain about the procedures that are compulsory in the case of procedures?

1016

Explain Rule based optimization in oracle apps?

864

Define ad-hoc reports?

857

How to enable tracing for document managers

812

Can you use concurrent program "gather schema statistics" to gather stats on sys schema in oracle apps?

890

Define autonomous transaction?

939

What is oracle apps (erp)?

929

What are cycles of ar?

861

Explain the uses of fsg?

878

What is mrc? Explain its uses

965

Define multi org ?

847

What is the firing sequence related with report triggers?

915

Explain about security attributes?

886

Define about profile option?

897

What are the steps in attaching reports with oracle applications?

819