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
Describe how the jdbc application works.
What is an escape syntax?
What is difference between odbc and jdbc?
Can we return resultset in java?
What is jdbc odbc?
How the JDBC application works?
Write an sql to find all records having all numeric characters in a field ?
Which package contains jdbc api?
Is jdbc faster than odbc?
What are the differences between execute, executequery, and executeupdate?
What is statement and preparedstatement in java?
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
What is JDBC Driver interface?
State the three different ways in which you can create a table?
Which Java and java.sql data types map to my specific database types?