SQLresult set is a set of rows from a database, as well as meta-information 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 BYclause 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.
Wikimedia Foundation. 2010.
Look at other dictionaries:
Set operations (SQL) — UNION operator= In SQL the UNION clause combines the results of two SQL queries into a single table of all matching rows. The two queries must have the same number of columns and compatible data types to unite. Any duplicate records are… … Wikipedia
set — set1 W1S1 [set] v past tense and past participle set present participle setting ▬▬▬▬▬▬▬ 1¦(put)¦ 2¦(put into surface)¦ 3¦(story)¦ 4¦(consider)¦ 5¦(establish something)¦ 6¦(start something happening)¦ 7¦(decide something)¦ … Dictionary of contemporary English
Set-aside — as a political measure was introduced by the European Union (EU) in 1988 to (i) help reduce the large and costly surpluses produced in Europe under the guaranteed price system of the Common Agricultural Policy; and (ii) to deliver some… … Wikipedia
Set-through neck — (or Set thru neck) is a method of joining the neck and the body of guitar (or similar stringed instrument), effectively combining bolt on , set in and neck through methods. It involves:* A pocket in the instrument s body for insertion of neck, as … Wikipedia
Set and setting — describes the context for psychoactive and particularly psychedelic drug experiences: one s mindset and the setting in which the user has the experience. This is especially relevant for psychedelic or hallucinogenic experiences; the term was… … Wikipedia
Set theory of the real line — is an area of mathematics concerned with the application of set theory to aspects of the real numbers. For example, one knows that all countable sets of reals are null, i.e. have Lebesgue measure 0; one might therefore ask the least possible size … Wikipedia
Set Fire to Flames — is a post rock band of thirteen musicians from Montreal, Canada, who have released two albums on Alien8 Recordings, FatCat Records.Both albums were recorded in states of little or no sleep, in varying levels of intoxication, and in physical… … Wikipedia
set theory — the branch of mathematics that deals with relations between sets. [1940 45] * * * Branch of mathematics that deals with the properties of sets. It is most valuable as applied to other areas of mathematics, which borrow from and adapt its… … Universalium
set — I. verb (set; setting) Etymology: Middle English setten, from Old English settan; akin to Old High German sezzen to set, Old English sittan to sit Date: before 12th century transitive verb 1. to cause to sit ; place in or on a seat 2 … New Collegiate Dictionary
Set (mythology) — In Ancient Egyptian mythology, Set (also spelled Seth, Sutekh or Seteh) is an ancient god, who was originally the god of the desert, storms, and chaos. Because of the developments in the Egyptian language over the 3,000 years that Set was… … Wikipedia