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
- 21345 Views
- HSBC, I also Faced
- E-Mail Answers
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
Why do we need jdbc driver?
What is the difference between setmaxrows(int) and setfetchsize(int)?
How do I insert an image file (or other raw data) into a database?
Explain about multiple implementations and drive manager?
What are the jdbc api components?
How can we set null value in jdbc preparedstatement?
What does jdbc do?
What is the meaning of “dirty read” in the database?
What is transaction processing in jdbc?
What is phantom read and which isolation level prevents it?
What is SQL Warning? How to retrieve SQL warnings in the JDBC program?
What is in terms of jdbc a datasource?
What is the use of callablestatement? Name the method, which is used to prepare a callablestatement.
What is a jdbctemplate?
What is drivermanager in java?
