An SQL result set is a set of rows from a database, as well as metadata about the query such as the column names, and the types and sizes of each column. Depending on the database system, 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. Precomputations often impose undesired performance impacts.
A result set is effectively a table. The ORDER BY clause can be used in a query to impose a certain sort condition on the rows. Without that clause, there is no guarantee whatsoever on the order in which the rows are returned.
Famous quotes containing the words result and/or set:
“That all [Berkeley’s] arguments, though otherwise intended, are, in reality, merely sceptical, appears from this, that they admit of no answer and produce no conviction. Their only effect is to cause that momentary amazement and irresolution and confusion, which is the result of scepticism.”
—David Hume (1711–1776)
“To Time it never seems that he is brave
To set himself against the peaks of snow
To lay them level with the running wave,
Nor is he overjoyed when they lie low,
But only grave, contemplative and grave.”
—Robert Frost (1874–1963)