Interested to Buy Any Domain ? << Click Here >> for more details...
select three highest values from a table.
- 1 Answers
- 5456 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 |
List some uses of dff (descriptive flex field) ?
There is currently a list of predefined auto cash rules, however I am wanting to know if you can customise and create a cash rule to specifically target an aging bucket i.e. 30 days
What is flexfield?
Differentiate apps schema from other schemas?
How can I define organization restriction?
Which are the attachments that are platform independent and become a part of the template?
What is the role of document manager?
Can any one pls tell the exact number of modules in Oracle Applications ? What are they and their catogery ( Like Manufacturing, Finance etc.. )Pls give the number.
I want to setup additional organizations, do I have to setup multiorg?
What is a token?
Where to define the parameters in the report?
Define about profile option?
Oracle Apps Technical 
