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
- 21609 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
The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?
What does the jdbc databasemetadata interface?
What is two-phase commit in the database?
What protocol does jdbc use?
How can I manage special characters when I execute an insert query?
Explain about multiple implementations and drive manager?
Why do I get UnsatisfiedLinkError when I try to use my JDBC driver?
How can you know about drivers and database information ?
What do you mean by batch processing in jdbc?
What does executequery return in java?
What is the advantage of namedparameterjdbctemplate?
How to make updates to updatable result sets in jdbc?
Differentiate between a statement and a preparedstatement.
code to insert values/rows into oracle database from a java swing textfield when a button is pressed(using preparedstatements)
What is batch processing and how to perform batch processing in jdbc?
