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

i have 1000 records in resultset, how to get first 100
records from resultset, because resultset fetch all 1000
records at a time?

Answer Posted / ravi

the is a syntax in sql 'limit'....using this u can get
desired number of rows...

suppose database having 1000 rows..

query will be:

select * from table limit 100;

first 100 rcds will be selected...

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is better odbc or jdbc?

917


What are jdbc?

903


What is drivermanager in jdbc?

914


What are the advantages of using preparedstatement in java?

918


How do I insert an image file (or other raw data) into a database?

913


What are the higher level apis under development on top of jdbc currently?

896


What are the three basic components of the odbc architecture?

865


What is the purpose of jdbc?

980


What are the differences between statement and preparedstatement interface?

926


What is executeupdate in java?

825


What is serialization and deserialization in java programming?

915


What is java soft framework?

935


What are the three parts of a jdbc url?

959


What is difference between jdbc and odbc?

943


What causes the "No suitable driver" error?

965