select three highest values from a table.
- 1 Answers
- 4626 Views
- I also Faced
- E-Mail Answers
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 |
More Oracle Apps AllOther Interview Questions
Which table is used to provide drill down from oracle gl into sub-ledger?
What is fsg? Explain its uses.
What is a flexfield?
What is a token?
What are conversions and interfaces?
What is data migration?
What is the concurrent program?
Which are the types of triggers?
What are the prerequsites for costing transactions?
What is fsg?
What are cycles of ar?
Define uses of key flexfield ?
Oracle Apps Technical 
