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:
“The innocence of those who grind the faces of the poor, but refrain from pinching the bottoms of their neighbour’s wives! The innocence of Ford, the innocence of Rockefeller! The nineteenth century was the Age of Innocence—that sort of innocence. With the result that we’re now almost ready to say that a man is seldom more innocently employed than when making love.”
—Aldous Huxley (1894–1963)
“But beauty is set apart,
beauty is cast by the sea,
a barren rock,
beauty is set about
with wrecks of ships....”
—Hilda Doolittle (1886–1961)