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
- 21607 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 java soft framework?
What is executequery in java?
What is getconnection method in java?
DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?
Give steps to connect to the db using jdbc?
What are the differences between stored procedure and functions?
Name the method, which is used to prepare a callablestatement.
what is the meaning of following code snippets Class c=class.forName(driverClassName); Driver d=(driver)c.newInstance();
What is batch processing and how to perform batch processing in jdbc?
How a database driver can be loaded with jdbc 4.0 / java 6?
What is jdbc url for mysql?
Describe odbc?
What is 2 phase commit?
What is the meaning of “dirty read” in the database?
Explain the role of driver in jdbc.
