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


Please Help Members By Posting Answers For Below Questions

What are types of resultset?

570


What is sqlwarning and discuss the procedure of retrieving warnings?

565


Why we use jdbc instead of odbc?

514


Explain about multiple implementations and drive manager?

574


What is jdbc stand for?

494






What is jdbc and odbc?

516


What happens if connection is not closed in jdbc?

504


what is the meaning of following code snippets Class c=class.forName(driverClassName); Driver d=(driver)c.newInstance();

4351


Under what circumstances, that all four drivers are used?

1915


Does sql allow null values ? Can we use it within where clause ?

521


How to retrieve warnings in jdbc?

533


Why do we need a jdbcrowset like wrapper around resultset?

783


What is jdbc explain?

502


Which interface handles transaction management in jdbc?

579


If you are given a choice to implement the code to either insert a record or update if already exist, which approach will you follow ?

586