1. Categories >> Software >> Java Related >> Java J2EE >> JDBC
  2. Suggest New Category

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

Question Posted / shaikrafi

Answers were Sorted based on User's Feedback



i have 1000 records in resultset, how to get first 100 records from resultset, because resultset f..

Answer / sumit

The question is not pretty clear. However, before retriving the records from the database if you want to make sure you get only 100 records in one hit. U can use the following API after creating the statement object.

Statement.setFetchSize(100);

Is This Answer Correct ?    6 Yes 0 No

i have 1000 records in resultset, how to get first 100 records from resultset, because resultset f..

Answer / chandra

There is two ways to getting the limited records from the
DB.
1)we can use sql command :
set rowcount 100 select * from mytab.

2)Instead of set rowcount you can use setMaxRow(100) method.

Is This Answer Correct ?    4 Yes 0 No

i have 1000 records in resultset, how to get first 100 records from resultset, because resultset f..

Answer / dmk.java@gmail.com

query should be prepare like this


select * from tab_name where rownum <= 100

Is This Answer Correct ?    6 Yes 3 No

i have 1000 records in resultset, how to get first 100 records from resultset, because resultset f..

Answer / kuldeep raaj sharma

SELECT TOP 100 from MyTable;

Is This Answer Correct ?    7 Yes 4 No

i have 1000 records in resultset, how to get first 100 records from resultset, because resultset f..

Answer / sri

ResultSet.getRow() will give you the row number where the
resultset cursor is in , check for ResultSet.getRow()==100
and then break out of the loop

Is This Answer Correct ?    4 Yes 2 No

i have 1000 records in resultset, how to get first 100 records from resultset, because resultset f..

Answer / 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

i have 1000 records in resultset, how to get first 100 records from resultset, because resultset f..

Answer / saket

GO ON LINK JAVATEACHER.CO.IN AFTER THAT CLICK JSP ,,,,THERE
IS AN EXAMPLE OF PAGINATION SHOW THAT EXAMPLE THAT IS
PERFECT EXAMPLE FOR U

Is This Answer Correct ?    1 Yes 1 No

i have 1000 records in resultset, how to get first 100 records from resultset, because resultset f..

Answer / 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

More JDBC Interview Questions

What is a PreparedStatement?

3 Answers   Infosys,

What is meant by jdbc?

0 Answers  

What is de-normalization?

1 Answers  

Which Driver is preferable for using JDBC API in Applets?

2 Answers  

Where can I find ojdbc14 jar file?

0 Answers  




What should be done for auto generating primary key id in a table ?

0 Answers  

How do we call a stored procedure from jdbc?

0 Answers  

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 ?

0 Answers  

How many rowset are available in jdbc?

0 Answers  

Explain the role of driver in jdbc.

0 Answers  

Can you define a foreign key, with a key from the same table?

2 Answers   IBM,

Which jdbc driver is the fastest driver?

0 Answers  

For more JDBC Interview Questions Click Here
Categories