i have 1000 records in resultset, how to get first 100
records from resultset, because resultset fetch all 1000
records at a time?
Answer Posted / ravi
the is a syntax in sql 'limit'....using this u can get
desired number of rows...
suppose database having 1000 rows..
query will be:
select * from table limit 100;
first 100 rcds will be selected...
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What are the different types of statements? How we can you use preparedstatement.
What is the purpose of jdbc resultset interface?
Under what circumstances, that all four drivers are used?
List some new features available in jdbc 4.0?
How does a custom RowSetReader get called from a CachedRowSet?
How can I get information about foreign keys used in a table?
What is jdbc servlet?
How to rollback a JDBC transaction?
What is meant by connection string?
How can we disable a constraint ?
Is there another way of dealing with the result set that could execute faster?
What is jdbc and its types?
What is jdbc and its advantages?
What are the steps required to execute a query in jdbc?
What is jdbc and explain jdbc architecture?