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 / syam kumar
SELECT * FROM emp order by emp_date asc limit 10;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are different types of transactions in ar? : oracle accounts receivable
How to clone the database using RMAN back
What is the difference between recovery and restoring of the oracle database?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
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
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
what are the tools used for oracle 10g in real time.
types of receipts and detail desription about recipts and tables effected by receipts?
What is Tax Categories?
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.
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What view would you use to determine free space in a tablespace?
What is mrc and what is its use? : oracle accounts receivable