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 is the definition of responsibility?

0 Answers  


Define uses of key flexfield ?

0 Answers  


What is the usage of the spawned object?

0 Answers  


What is a datalink?

0 Answers  


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

0 Answers  


What are the steps in attaching reports with oracle applications?

0 Answers  


What are cycles of ar?

0 Answers  


Explain about application?

0 Answers  


What responsibility do I need to use to setup organization?

0 Answers  


What is a flexfield?

0 Answers  


How can I setup a child org to be its own costing organization?

0 Answers  


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

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)