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:
“Mothers are likely to have more bad days on the job than most other professionals, considering the hours: round-the-clock, seven days a week, fifty-two weeks a year. . . . You go to work when you’re sick, maybe even clinically depressed, because motherhood is perhaps the only unpaid position where failure to show up can result in arrest.”
—Mary Kay Blakely (20th century)
“All national institutions of churches, whether Jewish, Christian or Turkish, appear to me no other than human inventions, set up to terrify and enslave mankind, and monopolize power and profit.”
—Thomas Paine (1737–1809)