Interested to Buy Any Domain ? << Click Here >> for more details...
select three highest values from a table.
- 1 Answers
- 5454 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?
Explain the mechanisms to trace the document manager?
Which are the kinds of report triggers?
What are the steps in attaching reports with oracle applications?
What is the menu?
How can I setup a child org to be its own costing organization?
How will you open a bc4j package in jdeveloper?
Explain the types of flexfields?
Define custom top and its purpose.
Define descriptive flexfield ?
What is the use of fnd logging
What are the types of journal entries?
Oracle Apps Technical 
