Interested to Buy Any Domain ? << Click Here >> for more details...
select three highest values from a table.
- 1 Answers
- 5515 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 are cycles of ar?
Which are the kinds of report triggers?
How to handle errors in customer interface?
Define descriptive flexfield ?
What is data migration?
what does 'unfreezing rollup groups' do?
What is a datalink?
What is a token?
We are using flow manufacturing in oracle to manufacte ATO products. The items reserve to the sales order at the time of Work Order-less Completion. After they are reserved, they cannot be transferred from location to location within the FG warehouse as they are reserved and not available for subiventory transfer. Any ideas on how we can move products around the warehouse without destroying the reservation?
What is fsg?
Is there any possibility for having custom schema at any time when it is required?
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
Oracle Apps Technical 
