Result set

Result set

An SQL result 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 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.


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

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”