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
Explain the steps in writing a java program using jdbc?
If you are given a choice to implement the code to either insert a record or update if already exist, which approach will you follow ?
Explain some new features available in jdbc 4.0?
What are the steps involved in establishing a connection using jdbc in java?
what is the meaning of following code snippets Class c=class.forName(driverClassName); Driver d=(driver)c.newInstance();
Explain how to make updates to the updatable resultsets.
How can you load the drivers?
What is odbc jdbc?
How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?
Under what circumstances, that all four drivers are used?
What is use of connection pooling?
How we store procedure in oralce for callable statements in jdbc
What class.forname does, while loading the drivers?
Which package is used for jdbc application?
How many categories of jdbc drivers are there?