subquery

子查询

常用释义

n. 子查询

扩展信息

子查询

称为子查询（subquery）。答案补充换句话说，子查询可以出现在语句的好多地方，出现在where后也可以，from后也可以，判 …

活用子查询

《Access 2003高手攻略》... ... 17－1 什么是“事件”（ Event） 8－4 活用子查询（ SubQuery） 15－1 善用数据访问页（ Data …

千变万化的子查询

国立空中大学 -... ... 10.1 结构化查询语言( SQL) 11.7 千变万化的子查询( subquery) 第二篇认识资料模型( data model) ...

支援子查询

支援子查询（subquery）为非结构化的查询，提供 BTREE 索引透过 SSL 连线，提供更安全的资料库复制功能以 UTF-8 与 U…

子查询句

请将下列SQL查询语言，改用多层次子查询句(Subquery)的写法作答。(8%)

巢状的子查询

巢状的子查询 (Subquery) 32 32 巢状的触发程序层级 32 32 每个资料表的非丛集索引 249 249 同时开启於一个 SQL Server4 执 …

子查询内

条件2.该table(满足条件1的table)与其他table结合(join)或位在子查询内(subquery)或在不可合并的视观表内(non-mergeable view).

例句

Within the body of a subquery, it is often necessary to refer to the value of a column in the active row of the main query.

在子查询的正文中，通常需要引用主查询的活动行中的列的值。

A reference to columns or expressions in the main table(s) is called an outer reference and the subquery is said to be correlated.

对主表中的列或表达式的引用被称作外部引用，并且这种子查询是相关的。

The EXISTS condition is TRUE if the subquery result contains at least one row, and FALSE if the subquery result does not contain any rows.

如果子查询结果至少包含一行，则 EXISTS 条件为 TRUE；如果子查询结果一行也不包含，则条件为 FALSE。

Number of optimizations for a query that contains at least one subquery.

包含至少一个子查询的查询的优化数。

Two types of queries can be used in the WHERE clause of an UPDATE statement: a scalar subquery and a table subquery.

两种查询可以用于 UPDATE 语句的 WHERE 子句中：标量子查询和表子查询。

The result of the scalar subquery first needs to be transferred to the federated server.

首先需要将标量子查询的结果传送到联邦服务器。

The IN operator is one of four SQL operators that you can use with a table subquery.

IN 操作符是可以用于表子查询的四个 SQL 操作符之一。

If the subquery (which must have one column) returns one row, then the value of that row is compared to the expression.

如果子查询（必须含有一列）返回一行，则该行的值将与表达式进行比较。

Casts may be required if the columns of the initial subquery do not have the same domains as those of the recursive subquery.

如果初始子查询的列与递归子查询的列具有不同的域，则可能需要进行转换。

Any null values returned by subquery or expression that are compared to test_expression using IN or NOT IN return UNKNOWN.

subquery 或 expression 使用 IN 或 NOTIN 与 test_expression 比较后返回的所有空值都将返回 UNKNOWN。

Is a constant, function, any combination of column names, constants, and functions connected by an operator or operators, or a subquery.

常量、函数以及由一个或多个运算符连接的列名、常量和函数的任意组合，或者是子查询。

A subquery that references one or more columns from its containing SQL statement is called a correlated subquery.

如果一个子查询中引用了包含查询语句的一个或多个字段，则该子查询就称为相关性子查询。

The SHIP3 operator contains the statement that shows the result of the scalar subquery being bound in as a host variable.

SHIP3 操作符包含一个语句，该语句表明标量子查询的结果放在一个主机变量中。

The query above contains a correlated subquery, since the main query and the subquery are relaying on the same table, the employees table.

以上查询包含一个相关子查询，因为主查询和子查询依靠于同一个表，即 employees 表。

The last section also describes the ALL, EXISTS, and SOME or ANY predicates, which can be used to express conditions on subquery results.

最后一节还描述了 ALL、EXISTS 和 SOME 或 ANY 谓词，这些谓词可用于表达子查询结果上的条件。

The main query does not contain a GROUP BY clause, and is not an aggregate query, or the subquery returns exactly one value.

主查询不包含 GROUPBY 子句并且不是汇总查询，或者子查询恰好返回一个值。

The number of times the subquery and its function is executed can vary with different access paths chosen by the optimizer.

子查询及其函数执行的次数会因优化器选择的访问路径的不同而异。

The first is the unnesting of the subquery into a join between the employee and sales_order tables.

第一个优化解除了职员与 sales_order 表之间连接中的子查询嵌套。

This extension, specifying a join, can be used instead of a subquery in the WHERE clause to identify rows to be removed.

这个扩展指定联接，可在 WHERE 子句中取代子查询来标识要删除的行。

The expression can be a constant or a column name, and the list can be a set of constants or, more commonly, a subquery.

该表达式可以是一个常量或一个列名，而列表可以是一组常量，通常为一个子查询。

The database server automatically attempts to convert the values returned by the recursive subquery to match those of the initial query.

数据库服务器会自动尝试转换由递归子查询返回的值，以便与初始查询的那些值匹配。

In this case, error 1242 means that the query execution failed because there was a problem in a subquery.

在这里，错误 1242 表示查询操作失败，由于子查询有问题。

The previous subquery in this statement cannot be evaluated independently of the outer query.

该语句中前面的子查询无法独立于外部查询进行计算。

Used with a subquery to test for the existence of rows returned by the subquery.

与子查询一起使用，用于测试是否存在子查询返回的行。

The only change we made here was to get rid of the subquery in the original qeury.

这里我们所做的惟一更改就是去掉了原始查询中的子查询。

Specifies the name of the table, view, user-defined function, or subquery for the associated data column.

指定表、视图、用户定义函数或关联数据列的子查询的名称。

The SELECT subquery in the INSERT statement can be used to add values into a table from one or more other tables or views.

INSERT 语句中的 SELECT 子查询可用于将一个或多个表或视图中的值添加到另一个表中。

Thus, a subquery can be thought of as a temporary table with statement scope.

因此，一个子查询可以认为是语句范围内的临时表（内联视图）。

subquery

扩展信息

例句

更新时间：2025-05-18 01:13