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

What are the different types of statements? How we can you use preparedstatement.

924


What is the purpose of jdbc resultset interface?

960


Under what circumstances, that all four drivers are used?

2379


List some new features available in jdbc 4.0?

880


How does a custom RowSetReader get called from a CachedRowSet?

1045


How can I get information about foreign keys used in a table?

933


What is jdbc servlet?

924


How to rollback a JDBC transaction?

1039


What is meant by connection string?

938


How can we disable a constraint ?

969


Is there another way of dealing with the result set that could execute faster?

977


What is jdbc and its types?

912


What is jdbc and its advantages?

997


What are the steps required to execute a query in jdbc?

901


What is jdbc and explain jdbc architecture?

971