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)
“There is nothing less to our credit than our neglect of the foreigner and his children, unless it be the arrogance most of us betray when we set out to “americanize” him.”
—Charles Horton Cooley (1864–1929)