i have 1000 records in resultset, how to get first 100
records from resultset, because resultset fetch all 1000
records at a time?
- 8 Answers
- 18775 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is jdbc an api?
What do you understand by jdbc statements?
What are the advantages of using jdbc datasource?
What does setautocommit do?
What are the different types of JDBC drivers?
How can I determine where a given table is referenced via foreign keys?
How to get the Database server details in java program?
Give an example for getXXX method?
Explain the difference between rowset vs. Resultset in jdbc?
What are the components of jdbc?
Is jdbctemplate thread safe?
How to move the cursor in scrollable resultset ?
What is jdbc driver in java?
What is jdbc thin client?
What are the different types of statements? How we can you use preparedstatement.
