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 / 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


Please Help Members By Posting Answers For Below Questions

What is the sql query to find the employee who has Nth maximum salary?

5429


What Are Cross Validation & Adi?

1205


Explain prerequisites and post activities of oracle database installation

2185


What is an Oracle database Partial Backup?

1206


i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2334


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2381


8. Supporting AP, AR and GL?

2362


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

2309


What is autocashrule set? : oracle accounts receivable

1499


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

3020


can u give guidance abt packages of plsql

2240


Difference between transaction type and transaction sources. : oracle accounts receivable

1073


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

1307


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.

2592


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

2792