Interested to Buy Any Domain ? << Click Here >> for more details...
A Table has 10,000 records,How can i get latest 10 dates
from the table.so that i can only store those 10 records
in to my Resultset Object,to reduce load on my app?
- 7 Answers
- 11837 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ravikumar.s
select * from (select * from tblname order by datecolumn
asc) where rownum<=10;
There is no keyword in oracle like limit, only we can fetch
through rownum
in mysql only this limit is available
ex: select col from tbl limit 20;
in sql server we use Top keyword instead of limit;
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
Could you please let me know the interfaces in OM / FA??
What is the difference between recovery and restoring of the oracle database?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
default triggers available for reports
What is autocashrule set? : oracle accounts receivable
How many segment are present in Oracle Manufacturing
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Is there any link between pr form(purchse requisition)and po form(purchase order)
types of receipts and detail desription about recipts and tables effected by receipts?
Difference between transaction type and transaction sources. : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
3. Steps in UAT?
