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;

Explain about application?

0 Answers  

---

Define about key flexfiled ?

0 Answers  

---

Define uses of key flexfield ?

0 Answers  

---

Explain Rule based optimization in oracle apps?

0 Answers  

---

What is the concurrent program?

0 Answers  

---

What is fsg?

0 Answers  

---

Define mrc ( multiple reporting currency)?

0 Answers  

---

What is a value set?

0 Answers  

---

Define template?

0 Answers  

---

How will you open a bc4j package in jdeveloper?

0 Answers  

---

Define request group ?

0 Answers  

---

Which are the Open interfaces in Oracle Order Management Module?

2 Answers   Oracle,

---