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 |
What is the definition of responsibility?
Define uses of key flexfield ?
What is the usage of the spawned object?
What is a datalink?
Does oracle support running of gather stats on sys schema in oracle apps?
What are the steps in attaching reports with oracle applications?
What are cycles of ar?
Explain about application?
What responsibility do I need to use to setup organization?
What is a flexfield?
How can I setup a child org to be its own costing organization?
What is patch and types of patches?As functional consultant how much knowledge i should have about patches?