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語句處理的總行數。這個總行數不包括子查詢處理的行數。
Correlated subqueries are often used to test whether relationships exist without regard to cardinality.
相關性查詢通常用于測試某種關系是否存在，而不管返回記錄集的大小，
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.
只能在頂級查詢中指定查詢提示，不能在子查詢指定。
Subqueries used in the subquery comparison test and set membership test both return data values from the subquery table.
在子查詢比較測試中使用的子查詢和在集合成員資格測試中使用的子查詢都從子查詢表返回數據值。
The expressions used in the SET clause can also be subqueries that return only one value.
SET子句中使用的表達式還可以是只返回一個值的子查詢。
Expressions may be reordered and subqueries may be transformed to improve processing efficiency.
可以對表達式進行重新排序并對子查詢進行轉換以提高處理效率。
Similarly, subqueries impose a certain order of join execution that may not be the most advantageous.
類似地，子查詢會使連接按照一定的順序執行，而這種順序也許不是最優的。
This tutorial describes subqueries stated as conditions in the WHERE clause, which are useful for simpler comparison queries.
本教程描述在WHERE子句中作為條件的子查詢，這些子查詢對于較簡單的比較查詢很有用。
The subqueries aggregate the sales for each sales person within the UPDATE statement.
這些子查詢通過UPDATE聚合了語句中每個銷售人員的銷售信息。
The ORDER BY clause is not valid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.
除非同時指定了TOP，否則ORDERBY子句在視圖、內聯函數、派生表和子查詢中無效。
These access operations translate to more complex joins or correlated subqueries in the equivalent SQL.
這些訪問操作會轉換成用等效的SQL表示的更為復雜的聯接或關聯子查詢。
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。
So the existence test applied to the following two subqueries return the same results.
因此，應用于以下兩個子查詢的存在測試返回相同的結果。
You can select, insert, and update the XML values using SQL statements with embedded XQuery subqueries.
使用具有嵌入的XQuery子查詢的SQL語句，可以選擇、插入并更新XML值。
Create or modify joins between tables, views, user-defined functions, or subqueries.
創建或修改表、視圖、用戶定義函數或子查詢間的聯接。
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列表中也不允許使用子查詢、聚合和常量表達式。
Next, several examples of FROM clause and select-list subqueries are presented.
接著，我們會給出一些關于FROM子句和select列表子查詢的例子。
Aggregate functions and subqueries are not permitted.
不允許聚合函數和子查詢。
This example uses two correlated subqueries to find the names of employees who have sold a particular product.
此示例使用兩個相關子查詢查找售出過某種特定產品的雇員的姓名。
No columns, variables, or subqueries appear in the expression.
表達式中沒有列、變量、或子查詢。
The rewrite phase is particularly important for queries that are very complex, such as queries with many subqueries or joins.
對于非常復雜的查詢，例如帶有很多子查詢或連接的查詢，重寫階段尤其重要。
Perhaps the most important use for the IN keyword is in nested queries, also called subqueries.
或許IN關鍵字最重要的用法是用在嵌套查詢（也稱作子查詢）中。
The article also demonstrated how to modify a more complex database schema by using embedded subqueries.
本文還演示了如何通過使用嵌入式子查詢來修改比較復雜的數據庫模式。
You can use the GROUP BY clause, subqueries, and joins in view definitions.
您可以在視圖定義中使用GROUPBY子句、子查詢和連接。
We need to pay attention to correlated subqueries and try to avoid using them whenever possible.
我們需要注意相關子查詢，并盡可能地避免使用它們。
There are two types of subqueries, uncorrelated and correlated.
有兩種類型的子查詢：不相關的和相關的。
We first replaced as many subqueries in the original query as we could and then used the UNION set operator instead of OR operator.
我們首先盡可能多地替換原始查詢中的子查詢，然后使用UNION集合運算符代替OR運算符。
The problem is solved by using either CASE expressions or subqueries.
這個問題是通過使用CASE表達式或子查詢來解決的。
Specifies the provider supports subqueries as defined in the SQL-92 Entry Level.
指定提供程序像在SQL-92EntryLevel中定義的那樣支持子查詢。
Note it is more complicated than once may think - multiple buffers of the same type might be allocated for example to handle subqueries.
注意，這里需要考慮的不只有一點—可能會分配多個同一種類型的緩存，例如用來處理子查詢。
Open SQL in ABAP 6. 1 supports joins among tables, subqueries, and most other SQL features of modern databases.
ABAP6.1中的OpenSQL支持表聯結、子查詢和現代數據庫的大多數其他SQL特性。
This is alleviated by aggressively rewriting subqueries as joins.
但是通過積極地將子查詢重寫成連接的形式，可以緩解這一問題。
There are three basic types of subqueries.
有三種基本的子查詢。
For example, constants, literal values, functions, variables, subqueries, and column names are expressions.
例如，常量、文字值、函數、變量、子查詢和列名稱均為表達式。
