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:
“If it is the result of a pure love, there can be nothing sensual in marriage. Chastity is something positive, not negative. It is the virtue of the married especially. All lusts or base pleasures must give place to loftier delights. They who meet as superior beings cannot perform the deeds of inferior ones.”
—Henry David Thoreau (1817–1862)
“We Russians have assigned ourselves no other task in life but the cultivation of our own personalities, and when we’re barely past childhood, we set to work to cultivate them, those unfortunate personalities.”
—Ivan Sergeevich Turgenev (1818–1883)