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

What do you mean by hz_ in customer tables? : oracle accounts receivable

1212


now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2288


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2259


Explain prerequisites and post activities of oracle database installation

2126


can we use lexical perameter in oracle plsql if yes how

2309


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

1215


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

1143


as a technical developer in oracle applications which type errors feced in your experience sofar

2320


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

1272


How to clone the database using RMAN back

2226


Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1269


Is there any link between pr form(purchse requisition)and po form(purchase order)

2715


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2257


what are the API of GL,PO,AP

2264


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2325