任何函数的返回值都是子句(在我们的示例中只有一行)中最后一个表达式的结果。
The return value of any function is the result of the last expression in that clause (in our examples there is only one line).
可以从WHERE子句中提取确定性函数调用，避免不必要的表扫描。
Deterministic function calls can be extracted from the WHERE clause to avoid unnecessary table scan.
函数返回类型的数据类型可以直接指定，或使用references子句指定。
The data type for the function return type can be specified directly or using the REFERENCES clause.
该函数的for子句循环通过包含在临时XML数据中的实体节点。
The FOR clause of this function loops through the entity nodes contained in the transient XML data.
这个函数不能出现在delete语句的where子句中，而只能出现在查询中。
This function cannot appear in a DELETE statement's WHERE clause. It is only allowed in queries.
sql表函数的使用使您可以将过程性逻辑放入到查询的from子句中。
The usage of SQL Table Functions allows you to push procedural logic into the FROM clause of a query.
例如，只需在列出监控表函数返回的应用程序数据的查询中添加where子句，就可以搜索CPU消耗量最大的应用程序。
For example, you can easily search for the applications consuming the highest amount of CPU by simply adding a WHERE clause to a query that lists application data from a monitoring table function.
xmlagg函数使用ORDERBY子句对组内元素进行排序。
XMLAGG functions use the ORDER BY clause to sort the elements within the group.
您可以将DELETEsparql语句与where子句结合使用以按名称而不是按uri查找数据，这将拥有与SQL版本相同的函数头。
You could use the DELETE SPARQL statement with a WHERE clause to find the data by name rather than URI, which would enable you to have an identical function header to the SQL version.
利用这些函数的PASSING 子句将参数从SQL语句传递给这些函数。
The parameter is passed to these functions from the SQL statement using the PASSING clause of these functions.
从概念上说，merge函数通过应用on子句过滤，将源表行与目标表行进行联接，所有联接的行都在目标中进行更新或者删除。
Conceptually, the merge function joins source table rows with target table rows by applying the on clause filter. All the joined rows are updated or deleted on the target.
从外部环境中导入的变量是在闭包函数定义的use子句中指定的。
Variables to be imported from the outside environment are specified in the use clause of the closure function definition.
如果在sql语句的select子句的XMLQUERY函数中使用xml谓词，则这些谓词不会从结果集中排除任何行，因此不能使用索引。
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语句以在XQuery函数中包括一个passing子句。
Alter the generated SQL statement to include a PASSING clause in the XQuery function.
WebSpheremq函数可以在任何可使用函数的地方进行调用：值子句、投影列表、查询过滤器、存储过程和触发器。
The WebSphere MQ functions can be invoked anywhere a function can be used: values clause, projection list, query filters, stored procedures, and triggers.
values子句还为用户指定的oid列的值包括了一个casting函数，因为该值必须强制转换成目标表的REFERENCE类型。
The VALUES clause also includes a casting function for the user-specified value of the OID column because the value must be cast into the REFERENCE type of the target table.
XQuerywhere子句可以包含任意复杂的嵌套表达式，甚至可以包含函数调用。
The XQuery where clause can consist of nested expressions of arbitrary complexity that can even include function calls.
如果WITHNOT variant子句被指定，那么函数就不能包含任何sql语句。
If WITH not VARIANT clause is specified, then the function cannot contain any SQL statements.
WHERE 子句调用XMLExists函数，指定一个XPath表达式，这个表达式使DB2找到 "zip"元素并检查元素值是否为 95116。"
The WHERE clause invokes the XMLExists function, specifying an XPath expression that prompts DB2 to navigate to the "zip" element and check for a value of 95116.
可以使用SQLObject的AND和OR函数来组合查询子句。
You can use SQLObject's and and OR functions to combine query clauses.
where子句使用DB2的XMLExists函数限制查询所返回的数据。
The WHERE clause USES DB2's XMLExists function to restrict the data to be returned.
for子句中的distinct -values函数返回一个列表，其中包含在items表的comments列中的所有Comment中发现的所有不同的productid值。
The distinct-values function in the for clause returns a list of all the distinct values of ProductID that are found inside comments in the comments column of the Items table.
这个子句允许sql表函数包含UPDATE、DELETE、INSERT和merge语句。
This clause allows an SQL Table function to contain UPDATE, DELETE, INSERT and MERGE statements.
可以把这个函数看作相当于带WHERE 子句的SQLSELECT语句。
Think of this function as the equivalent to an SQL SELECT statement with a WHERE clause.
对于select子句中的xmlquery函数，默认情况下传递purchaseorder表的porder列。
For the xmlquery function in the SELECT clause, the porder column of the purchaseorder table is passed by default.
还可以看到“set”子句给xml列“info”设置一个新值，这个新值是一个XMLQUERY函数的结果。
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.
下面的案例研究展示如何迁移这样一个报告：报告在分析摘要函数的withinset子句外部的一个表达式中使用nestedset函数。
The following case study illustrates the migration of a report that USES the nestedSet function in an expression outside the within set clause of analytic summary function.
在一个分析摘要函数(比如rank)的withinset子句外部使用nestedset函数的报告将生成以下错误。
A report using the function nestedSet outside the within set clause of an analytic summary function (such as rank) produces the following error.
olap函数可以包括在一个select列表的表达式中或select语句的ORDERby子句中。
An OLAP function can be included in expressions in a select-list or the ORDER BY clause of a select-statement.
FROMsql子句定义了特定的函数，可以使用该函数将将一个值转换成表示结构化类型的内置数据类型。
The FROM SQL clause defines the specific function that will be used to transform a value to a built-in data type value representing the structured type.
应用推荐