select three highest values from a table.
- 1 Answers
- 4928 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is patch and types of patches?As functional consultant how much knowledge i should have about patches?
How to import invoices into oracle receivables?
Is there any documentation on how to setup an organization?
Define the steps for customizing form?
How to enable tracing for document managers
What is the use of fnd logging
What is the significance of profile option “responsibility trust level”.
What are Quick pick and quick codes
Explain the profile option 'node trust level'.
How can I define organization restriction?
Differentiate apps schema from other schemas?
Does oracle support partitioning of tables in oracle apps?
Oracle Apps Technical 
