A result set is the set of results returned by a query, usually in the same format as the database the query is called on.[1] For example, in SQL, which is used in conjunction with relational databases, it is the result of a SELECT query on a table or view and is itself a non-permanent table of rows, and could include metadata about the query such as the column names, and the types and sizes of each column. In an object database, the result set is usually a collection of objects from the database.
Depending on the database, the number of rows in the result set may or may not be known. Usually, this number is not known up front because the result set is built on the fly. A cursor can be used by client applications to fetch a few rows of the result set at a time.[2]