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:
“A perfect personality ... is only possible in a state of society where man is free to choose the mode of work, the conditions of work, and the freedom to work. One to whom the making of a table, the building of a house, or the tilling of the soil, is what the painting is to the artist and the discovery to the scientist,—the result of inspiration, of intense longing, and deep interest in work as a creative force.”
—Emma Goldman (1869–1940)
“Whither I go, thither shall you go too;
Today will I set forth, tomorrow you.”
—William Shakespeare (1564–1616)