select three highest values from a table.
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 |
How will you open a bc4j package in jdeveloper?
What are the relationships I can define in a multi org environment?
What are cycles of gl, ap, and ar?
How can I define organization restriction?
Explain the types of flexfields?
Explain the uses of mrc?
Define the types of validation?
What is the significance of profile option “responsibility trust level”.
Define template?
Define ad-hoc reports?
Does oracle support partitioning of tables in oracle apps?
Where do we use custom.pll?