Result Set Only One Row. Initially the cursor is positioned before the first row. With UP TO 1 ROWS you tell the database to pass only one row in its tabular result set and the internal table contains only one line.
Viewed 7k times 2. However in case the query optimizer uses an index to process the query the rows will appear as they are stored in the index key order. The javasqlResultSet interface represents the result set of a database query.
But be aware that the returned row is not defined.
This cursor is a pointer that points to one row of data in the ResultSet. The method ResultSetnext moves the cursor to the next row. Initially the cursor is positioned before the first row. The term result set refers to the row and column data contained in a ResultSet object.