subquery
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 … Справочник технического переводчика
