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 |
What will be your partitioning strategy on gl_balances? Your views please?
What is data migration?
Define uses of key flexfield ?
I want to setup additional organizations, do I have to setup multiorg?
Define multi org ?
How will you open a bc4j package in jdeveloper?
Define template?
Define request group ?
What are cycles of gl?
What are the benefits of substitution in oa framework
Define the types of validation?
Which are the attachments that are platform independent and become a part of the template?