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 / a kumar
If your intention is to dislay only 100 records to the
user, then better make the change the query to retrieve
first 100 recs. (like say fetch first 100 rows in Db2).
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is batch processing and how to perform batch processing in jdbc?
How to move the cursor in scrollable resultset ?
Why did my jdbc code throw a rollback sqlexception?
What are the differences between setmaxrows(int) and setfetchsize(int)?
What are different types of ResultSet?
Explain what should be done when a SQL exception is raised?
What is drivermanager in jdbc?
Name different methods for getting streams.
How do you insert images into database using jdbc?
Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?
Does jdbctemplate close connection?
Explain how data flows from view to db and reverse
What is meant by jdbc and odbc?
Explain about DSN?
How you restrict a user to cut and paste from the html page using java programing?