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;

I want to setup additional organizations, do I have to setup multiorg?

0 Answers  

---

Define oracle suite?

0 Answers  

---

What will be your partitioning strategy on gl_balances? Your views please?

0 Answers  

---

What responsibility do I need to use to setup organization?

0 Answers  

---

Define request group ?

0 Answers  

---

What is a datalink?

0 Answers  

---

Define application top?

0 Answers  

---

Differentiate apps schema from other schemas?

0 Answers  

---

Define ad-hoc reports?

0 Answers  

---

Define mrc ( multiple reporting currency)?

0 Answers  

---

Explain the uses of fsg?

0 Answers  

---

Which are the types of triggers?

0 Answers  

---