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
- 20985 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 a middleware?
What happens if we don't close the connection in jdbc?
Is odbc an api?
What does the connection object represents?
What is encrypted connection?
What is jdbc and its types?
Does sql allow null values ? Can we use it within where clause ?
Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.
Are all the required JDBC drivers to establish connectivity to my database part of the JDK?
How can you use preparedstatement in jdbc?
What is use of connection pooling?
What is sqlwarning and discuss the procedure of retrieving warnings?
Explain jdbc savepoint?
What is the return type of class.forname() method?
What are the types of jdbc drivers that exist?
