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
- 11592 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
i want to know about the javaBean.what is its purpose and how it can use in Forms.
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
How do you create a credit note against an invoice? : oracle accounts receivable
How to clone the database using RMAN back
What is supporting issues GL AP and AR?
Give two methods you could use to determine what DDL changes have been made.
What is an Oracle database Full Backup?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
8. Supporting AP, AR and GL?
What Are Cross Validation & Adi?
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?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What do you mean by Oracle MEDIA RECOVERY?
What is an Oracle database Partial Backup?
Could you please let me know the interfaces in OM / FA??
