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:
“Fantasy is a product of thought, Imagination of sensibility. If the thinking, discursive mind turns to speculation, the result is Fantasy; if, however, the sensitive, intuitive mind turns to speculation, the result is Imagination. Fantasy may be visionary, but it is cold and logical. Imagination is sensuous and instinctive. Both have form, but the form of Fantasy is analogous to Exposition, that of Imagination to Narrative.”
—Sir Herbert Read (1893–1968)
“Men would never be superstitious, if they could govern all their circumstances by set rules, or if they were always favoured by fortune: but being frequently driven into straits where rules are useless, and being often kept fluctuating pitiably between hope and fear by the uncertainty of fortune’s greedily coveted favours, they are consequently for the most part, very prone to credulity.”
—Baruch (Benedict)