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 |
Explain about application?
Define about key flexfiled ?
Define uses of key flexfield ?
Explain Rule based optimization in oracle apps?
What is the concurrent program?
What is fsg?
Define mrc ( multiple reporting currency)?
What is a value set?
Define template?
How will you open a bc4j package in jdeveloper?
Define request group ?
Which are the Open interfaces in Oracle Order Management Module?