Aresult set is the set of results returned by a query, usually in the same format as thedatabase the query is called on.[1] For example, inSQL, which is used in conjunction withrelational databases, it is the result of aSELECT query on atable orview and is itself a non-permanent table of rows, and could includemetadata about the query such as the column names, and the types and sizes of eachcolumn. In anobject database, the result set is usually acollection 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 builton the fly. Acursor can be used by client applications to fetch a few rows of the result set at a time.[2]
In SQL, there is no guarantee that the rows of a result set returned by aSELECT query are in any particular order unless theORDER BY clause is used in the query, which sorts the rows of the result set in ascending or descending order based on one or more columns.[2]
 | Thisdatabase software-related article is astub. You can help Wikipedia byexpanding it. |