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?
- 8 Answers
- 21354 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
What is jdbc and odbc?
Does JDBC support stored procedures?
What are the main steps in java to make JDBC connectivity?
Explain how to make updates to the updatable resultsets.
What port does jdbc use?
What is jdbc driver?
What is setautocommit in jdbc?
What are the packages are used in jdbc?
What is jdbc vs odbc?
What do you understand by jdbc datasource?
There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?
What happens if connection is not closed in jdbc?
Where is jdbc url mysql?
What is resultset?
How can I get or redirect the log used by DriverManager and JDBC drivers?
