subqueries

子查询

常用释义

子查询

扩展信息

子查询

三、子查询(Subqueries):子查询是在where子句中包含的查询语句，是由系列简单构成的复杂查询。问：谁与smith在同一部门 …

次查询

次查询（Subqueries）　任何数目的次查询可以存在型态的任意层级中，而且次查询可以使用巢状结构，但是却不允许空的次查 …

例句

The previous restrictions apply to any subqueries in the FROM clause of the view, just as they apply to the view itself.

上述限制适用于视图的 FROM 子句中的任何子查询，就像其应用于视图本身一样。

The uncorrelated subqueries do not rely on the main query for information; hence they increase the power and flexibility of your main query.

不相关的子查询不依靠主查询来获取信息；因此，它们增加了主查询的能力和灵活性。

Total number of rows processed by the SQL statement. This total does not include rows processed by subqueries of the SQL statement.

sql 语句处理的总行数。这个总行数不包括子查询处理的行数。

Note: Transactions containing DML statements with subqueries should use serializable isolation to guarantee consistent read.

如果事务中存在使用了子查询的 DML 语句，应该使用串行化隔离来保证一致性的读取。

Query hints can be specified only in the top-level query, not in subqueries.

只能在顶级查询中指定查询提示，不能在子查询指定。

Similarly, subqueries impose a certain order of join execution that may not be the most advantageous.

类似地，子查询会使连接按照一定的顺序执行，而这种顺序也许不是最优的。

The ORDER BY clause is not valid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.

除非同时指定了 TOP，否则 ORDERBY 子句在视图、内联函数、派生表和子查询中无效。

Removed inaccurate content about using subqueries in scalar_expression.

删除了有关在 scalar_expression 中使用子查询的不准确内容。

The statement must not contain subqueries, outer joins, or self-joins.

语句不能包含子查询、外部联接或自联接。

UNION and JOIN within a FROM clause are supported within views and in derived tables and subqueries.

视图、派生表和子查询中均支持 FROM 子句内的 UNION 和 JOIN。

You can select, insert, and update the XML values using SQL statements with embedded XQuery subqueries.

使用具有嵌入的 XQuery 子查询的 SQL语句，可以选择、插入并更新 XML 值。

This includes SELECT lists of subqueries and SELECT lists inside INSERT statements.

其中包括子查询的 SELECT 列表和 INSERT 语句中的 SELECT 列表。

Also, subqueries, aggregates, and constant expressions are not allowed in the ORDER BY list.

此外，在 ORDERBY 列表中也不允许使用子查询、聚合和常量表达式。

Aggregate functions and subqueries are not permitted.

不允许聚合函数和子查询。

No columns, variables, or subqueries appear in the expression.

表达式中没有列、变量、或子查询。

Perhaps the most important use for the IN keyword is in nested queries, also called subqueries.

或许 IN 关键字最重要的用法是用在嵌套查询（也称作子查询）中。

You can use the GROUP BY clause, subqueries, and joins in view definitions.

您可以在视图定义中使用 GROUPBY 子句、子查询和连接。

更新时间：2025-05-16 12:54