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;

Define oracle suite?

0 Answers  

---

Define data group?

0 Answers  

---

Define mrc ( multiple reporting currency)?

0 Answers  

---

I have total 4 yrs experience in one IT company,and loking for a job change. I have one yr expereince in oracle apps - support work(not particularly one module) .and the remaining experience in SQL and PL/SQL . I heard that oracle database , there is no much openings outside. Now I am planning to take training in oracle finance modules- functional . Is it a right decision to learn oracla apps or Do I need to look offers with oracle database only ?

0 Answers  

---

What is a token?

0 Answers  

---

How to import invoices into oracle receivables?

0 Answers  

---

Define multi org ?

0 Answers  

---

List some uses of dff (descriptive flex field) ?

0 Answers  

---

Explain the types of flexfields?

0 Answers  

---

What are the interfaces in Oracle Project Costing and Oracle Project Billing?

3 Answers   KPIT,

---

Define descriptive flexfield ?

0 Answers  

---

Define record group?

0 Answers  

---