Hi, When a query returns a big resultset of 50000 rows, is it possible to use SQL to limit the rows number like only returning 2000-3000 rows, rather than using "select top 2000". Thank you for your help.
throws SQLExceptionRetrieves the number of result set rows that is the default fetch size for ResultSet objects generated from this Statement object. If this Statement object has not set a fetch size by calling the method setFetchSize, the return value is implementation-specific.
Returns: the default fetch size for result sets generated from this Statement object Throws: SQLException - if a database access error occurs