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

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.

2460


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2486


what is difference between inner join & nested query or subqueries

2991


What are different types of transactions in ar? : oracle accounts receivable

1236


What is an Oracle database Partial Backup?

1123


What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1241


where the dff data will be stored

2370


What is Tax Categories?

2066


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2072


i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2278


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2032


can we use lexical perameter in oracle plsql if yes how

2282


What is the difference between conversions and interfaces? : oracle accounts receivable

1146


Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1740


Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1116