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
- 21328 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 the use of jdbc api?
Explain different types of locks in jdbc?
How can I manage special characters when I execute an insert query?
What is the difference between executing, executequery, executeupdate in jdbc?
What happens if we don't close the connection in jdbc?
What is jdbc class forname?
Why jdbc is used in java?
What are the differences between stored procedure and functions?
What is drivermanager in jdbc?
How vendor Naming registry supports JNDI?
What does the jdbc resultsetmetadata interface?
How do I start debugging problems related to the JDBC API?
Which is faster jdbc or odbc?
How can we set null value in jdbc preparedstatement?
What class.forname will do while loading drivers of jdbc?
