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?
Answer Posted / rajesh
select * from(select * from table_name order by date_column
desc) where rowid<=10
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What Are Cross Validation & Adi?
Difference between transaction type and transaction sources. : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
what is semphore explian it?
What is an Oracle database Full Backup?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
as a technical developer in oracle applications which type errors feced in your experience sofar
Differentiate between transaction type and transaction source? : oracle accounts receivable
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
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 importance of batch source set up in ar? : oracle accounts receivable
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Give two methods you could use to determine what DDL changes have been made.