subquery

subquery
A query embedded within a more extensive query, relating only to the data returned by the parent query.

Wikipedia foundation.

Игры ⚽ Нужен реферат?

Look at other dictionaries:

  • Correlated subquery — In a SQL database query, a correlated sub query is a sub query (a query nested inside another query) that uses values from the outer query in its WHERE clause. The sub query is evaluated once for each row processed by the outer query. Here is an… …   Wikipedia

  • Condition (SQL) — A relational database management system uses SQL conditions or expressions in WHERE clauses and in HAVING clauses to SELECT subsets of data. Types of condition Many conditions compare values for (for example) equality, inequality or similarity.… …   Wikipedia

  • PowerBuilder — Infobox Software name = PowerBuilder caption = developer = Sybase released = July, 1991 frequently updated = yes programming language = Powerscript operating system = Microsoft Windows language = English, Japanese (Several languages supported for …   Wikipedia

  • Delete (SQL) — In the database structured query language (SQL), the DELETE statement removes one or more records from a table. A subset may be defined for deletion using a condition, otherwise all records are removed.[1] Contents 1 Usage 2 Examples 3 …   Wikipedia

  • View (database) — In database theory, a view consists of a stored query accessible as a virtual table in a relational database or a set of documents in a document oriented database composed of the result set of a query or map and reduce functions. Unlike ordinary… …   Wikipedia

  • Gadfly (database) — Gadfly is a relational database management system written in Python. Gadfly is a collection of Python modules that provides relational database functionality entirely implemented in Python. It supports a subset of the standard RDBMS Structured… …   Wikipedia

  • Common table expressions — A Common Table Expression (in SQL) is a temporary named result set, derived from a simple query and defined within the execution scope of a SELECT, INSERT, UPDATE, or DELETE statement. CTE can be thought of as an alternatives to derived tables… …   Wikipedia

  • Common table expression — A Common Table Expression, or CTE, (in SQL) is a temporary named result set, derived from a simple query and defined within the execution scope of a SELECT, INSERT, UPDATE, or DELETE statement. CTEs can be thought of as alternatives to derived… …   Wikipedia

  • подзапрос — Запрос, вложенный в SQL операторы. [http://www.morepc.ru/dict/] Тематики информационные технологии в целом EN subquery …   Справочник технического переводчика

Share the article and excerpts

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