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

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.

2522


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

1281


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2074


Differentiate between transaction type and transaction source? : oracle accounts receivable

1115


What is auto invoicing? : oracle accounts receivable

1160


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2400


Explain about party and customer in ar : oracle accounts receivable

1211


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

1222


What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3937


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2072


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

2280


Explain prerequisites and post activities of oracle database installation

2133


difference of using cursor for loop and open,fetch,close.which one is better

1805


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

2601


How would you determine who has added a row to a table?

2316