Interested to Buy Any Domain ? << Click Here >> for more details...
select three highest values from a table.
- 1 Answers
- 5361 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 |
Define ad-hoc reports?
What are cycles of ap?
What is mrc? Explain its uses
What responsibility do I need to use to setup organization?
Which are the kinds of report triggers?
Explain the uses of fsg?
What is the usage of the spawned object?
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?
Where are tables created?
What is the role of document manager in oracle purchasing?
What are cycles of gl, ap, and ar?
What is the purpose of temp tables in interface programs?
Oracle Apps Technical 
