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;

What is flexfield? And types of flexfields?

0 Answers  

---

What is patch and types of patches?As functional consultant how much knowledge i should have about patches?

0 Answers  

---

What responsibility do I need to use to setup organization?

0 Answers  

---

List some uses of dff (descriptive flex field) ?

0 Answers  

---

What is the firing sequence related with report triggers?

0 Answers  

---

---

How can I know if I am using multi org?

0 Answers  

---

Which are the kinds of report triggers?

0 Answers  

---

What is user exits

0 Answers  

---

Explain about application?

0 Answers  

---

Does oracle support running of gather stats on sys schema in oracle apps?

0 Answers  

---

select three highest values from a table.

1 Answers  

---

What is user exits and explain the types?

0 Answers  

---