select three highest values from a table.



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

Post New Answer

More Oracle Apps AllOther Interview Questions

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

0 Answers  


What is data migration?

0 Answers  


Define uses of key flexfield ?

0 Answers  


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

0 Answers  


Define multi org ?

0 Answers  






How will you open a bc4j package in jdeveloper?

0 Answers  


Define template?

0 Answers  


Define request group ?

0 Answers  


What are cycles of gl?

0 Answers  


What are the benefits of substitution in oa framework

0 Answers  


Define the types of validation?

0 Answers  


Which are the attachments that are platform independent and become a part of the template?

0 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)