Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answer Posted / laxman

SELECT * FROM emp group by emp_date asc limit 10;

Is This Answer Correct ?    2 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2871


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1134


What is Tax Categories?

2116


A scenario for amount correction & how to use amount correction functionality in AP invoices

2142


How would you go about increasing the buffer cache hit ratio?

2608


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1097


Explain the use of table functions.

2494


What is the mandatory setup in cyclecount ?

2758


Can we modify approve purchase order?if yes what is navigation?

2014


What is the use of lockboxes? : oracle accounts receivable

1211


Are These Dff's Flexible?

1180


default triggers available for reports

2225


What is an Oracle database Partial Backup?

1168


What is the difference between recovery and restoring of the oracle database?

1227


HOW TO SPOT AHIERARCHY?

2302