This no longer works if you use arbitrary tables and fields to specify the from clause or the result clause dynamically, though, because the result set types cannot be determined at programming time.
但是，如果使用任意数量的表和字段动态地指定from子句或result子句，就不能这样了，因为在编程时无法确定结果集类型。
In the next example, the previous query is modified, by adding an ORDER by siblings clause to get the siblings in the result sorted by NAME.
在下一个示例中，会修改以前的查询，添加一个ORDERBYsiblings子句，从按照NAME排序的结果中获取同级查询结果。
For example, if used in a SELECT clause, it returns the partition number for each row of the table that was used to form the result of the SELECT statement.
例如，如果用在一个select子句中，那么该函数将返回表中组成select语句结果的每一行的分区号。
XMLQUERY is often used in the SELECT clause of an SQL query to extract or construct XML values based on the XML document in a given row of the result set.
在SQL查询的select子句中，常常使用XMLQUERY根据结果集的给定行中的XML文档提取或构造xml值。
The result of the current iterative select statement is merged with the result of the initial select statement and all results returned by the previous iterations using a UNION ALL clause.
使用UNIONALL子句，可将当前的迭代SELECT语句的结果与初始 SELECT 语句的结果以及之前的迭代返回的所有结果合并在一起。
The "columns" clause, spanning lines 3 to 5, identifies the specific XML elements that will be mapped to output columns in the SQL result set, specified on line 1.
第3到5行的“columns ”子句标识出将被映射到第一行指定的SQL结果集中的输出列的特定xml元素。
Query 11 returns the same logical result as Query 10 but USES XMLTABLE and the SQL group by clause.
查询10返回与查询9相同的逻辑结果，但使用的是SQL的groupby子句。
The result of that subquery then becomes a value in the WHERE clause expression
它的结果会成为where语句表达式中的一个值。
The return value of any function is the result of the last expression in that clause (in our examples there is only one line).
任何函数的返回值都是子句(在我们的示例中只有一行)中最后一个表达式的结果。
This is due to the semantics of SQL: without a WHERE clause, SQL queries do not filter out any rows from the table in the returned result set.
这是由于SQL的语义导致的：没有了where子句，SQL查询就不会在返回的结果集中过滤掉表中的任何行。
Declare cursors for each of the result sets to be returned that specify the WITH return clause.
对于每个将要返回的结果集，使用WITHreturn子句声明游标。
The temporarily created field SORT is used within the ORDER BY clause, to get the result returned in the depth-first sequence.
临时创建的字段sort用于ORDERby子句内，以便按深度优先顺序获得返回的结果。
These STAGE 3 predicates, especially those that reject a majority of the rows, are usually the result of old VSAM logic that did not utilize a WHERE clause.
这些STAGE3谓词，特别是拒绝大部分行的那些，通常是不使用WHERE 子句的旧有VSAM逻辑的结果。
The pseudo column LEVEL can be used in the ORDER BY clause to return the result set in search breadth first sequence.
可在ORDERBY 子句中使用伪列LEVEL按照搜索宽度优先顺序返回结果集。
Because the UPDATE is in the FROM clause it is easy to use the standard SUM to aggregate the end result.
因为UPDATE在from子句中，所以很容易使用标准SUM来聚集最终结果。
A values clause returns a table of values by specifying an expression for each column in the result table.
values子句通过指定结果表中的各列表达式来返回一个值表。
The variable to retrieve the result, RtnVal, is associated with the parameter marker in the USING clause.
用来检索结果的变量rtnval与using子句中的参数标记有关联。
Finally, note how the single row VALUES clause is used in the return statement to return the end result as a single-row table.
最后，注意在return语句中使用了单行的values子句，以便将最后的结果以单行的表的形式返回。
If you use XML predicates in the XMLQUERY function in the select clause of an SQL statement, these predicates do not eliminate any rows from the result set and therefore cannot use an index.
如果在sql语句的select子句的XMLQUERY函数中使用xml谓词，则这些谓词不会从结果集中排除任何行，因此不能使用索引。
Listing 11 also demonstrates Zorba's support for the XQuery where clause, which is commonly used to filter the output result set.
清单11还显示Zorba对XQuerywhere子句的支持，它通常用于过滤结果集的输出。
You also see that the "set" clause assigns a new value to the XML column "info", and that this new value is the result of an XMLQUERY function.
还可以看到“set”子句给xml列“info”设置一个新值，这个新值是一个XMLQUERY函数的结果。
If you add an order by clause, to order by the extracted city value, the result set still remains the same: Paris, Paris, and Paris are treated as the same value.
如果通过添加order BY子句按提取的city值排序，那么结果集仍然是相同的：paris、paris和paris被当作相同的值。
Put a secondary idea in a dependent adverb clause if you want to express an idea of time, place, cause or reason, purpose or result, concession or contrast.
在表达关于时间、地点、原因、目的或结果、让步或转折等内容的时候，把它们都放在副词从句位置。
First, include in the index all the columns in the WHERE clause, so that index screening can be used to reject unqualified rows from the result set.
首先，在索引中包括WHERE子句中的所有列，这样，就可以使用索引形成的屏蔽来拒绝结果集中不合格的行。
If it is not immediately obvious why the error is occurring, examine the query carefully and trace the type of the result of each clause from the data source to the point where the error is occurring.
如果发生此错误的原因不十分明显，请仔细检查查询，并跟踪从数据源到错误发生点的每个子句的结果的类型。
If it is not immediately obvious why the error is occurring, examine the query carefully and trace the type of the result of each clause from the data source to the point where the error is occurring.
如果发生此错误的原因不十分明显，请仔细检查查询，并跟踪从数据源到错误发生点的每个子句的结果的类型。
应用推荐