The hierarchical query clause consists of two portions.
分级查询子句由两部分组成。
Click each column in the query clause to fill in the clause.
单击查询子句中的每一列以填写该子句。
The hierarchical query clause is easier to understand than the RCTE syntax.
与RCTE语法相比，分级查询子句较更容易理解。
This example shows how to use method syntax on the results of a query clause.
此示例演示如何对查询子句的结果使用方法语法。
To get all subordinates over all levels, the PRIOR operator must be added to the CONNECT BY part of the hierarchical query clause.
要获取所有级别上的所有下属，必须将PRIOR运算符添加到分级查询子句的CONNECTBY部分。
The following example shows a SELECT statement with a hierarchical query clause to return all direct subordinates for the manager Meier (employee number 101).
下列示例显示使用一个SELECT语句和一个分级查询子句来返回Meier经理（雇员编号为 101）的所有直接下属。
Adding an ORDER siblings BY clause which is only allowed in composition with the hierarchical query clause and will return the siblings in the predefined sequence.
添加一个ORDERSIBLINGSBY子句，该子句只能与分级查询子句组合使用，并且将按预先定义的顺序返回同级查询结果。
The application of the NON EMPTY clause, alters the query from returning all members, to just returning those that have measure values.
NONempty子句的应用将查询从返回所有成员修改为仅返回具有度量值的那些成员。
Each matching binding of the graph pattern's variables to the model's nodes becomes a query solution, and the values of the variables named in the SELECT clause become part of the query results.
将每个图形模式变量的绑定与模型节点进行匹配就成为一种查询解决方案，而select子句中指定的变量值则成为查询结果的一部分。
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排序的结果中获取同级查询结果。
Or, if you'd like only certain rows to be replicated, you just use a WHERE clause in your query.
或者，如果只希望复制表的某些行，那么只需要在查询中使用where子句。
For statistical view, the ENABLE query optimization clause will cause the view, and its associated statistics to be used to improve the query optimization.
对于统计视图，ENABLEQUERYoptimization子句将导致该视图以及与之相关联的统计信息被用于改进查询优化。
It's usual to explicitly set the model to use as the source for the query, unless otherwise specified with a FROM clause in the RDQL itself.
通常直接设置模型用作查询的源，除非在RDQL中使用FROM子句指定了其他的源。
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 'DISABLE QUERY OPTIMIZATION' clause may be used to prevent the optimizer from considering use of a particular MQT.
DISABLEQUERYOPTIMIZATION'子句可以用来防止优化器考虑使用特定的MQT。
In addition, the return clause in this query contains conditional logic to determine if an E-mail element is present in a given customer's record.
此外，这个查询中的return子句包含一个条件逻辑，用于判断给定客户的记录中是否存在e- mail元素。
The WebSphere MQ functions can be invoked anywhere a function can be used: values clause, projection list, query filters, stored procedures, and triggers.
WebSpheremq函数可以在任何可使用函数的地方进行调用：值子句、投影列表、查询过滤器、存储过程和触发器。
Usage: This parameter controls the decision on when the NON EMPTY clause is applied to the query MDX.
用法：该参数控制何时向查询MDX应用NONempty子句的决策。
The SELECT clause specifies what the query should return — in this case, a variable named url.
select子句指定查询应当返回的内容，在这个例子中，返回的是名为url的变量。
If you want to disable the usage of the constraints by the SQL compiler, you can use the disable QUERY OPTIMIZATION clause. For example.
如果您想通过编译器禁用约束，那么可以使用DISABLEQUERYoptimization子句。
Subsequent portions of the query use the XQuery where clause to filter returned data further and to transform portions of the selected comments into new XML fragments.
该查询中随后的部分使用XQuerywhere子句进一步过滤返回的数据，并将选中的评论的一些部分转换成新的xml片段。
Include and instantiate the posts model, create a where clause and run a standard delete query.
包括并实例化posts模型，创建where子句并运行标准的delete查询。
Completing a query with the return clause.
用return子句完成查询。
The Doctrine_Pager object then executes the query with the appropriate LIMIT clause and retrieves only the required subset of records.
然后，Doctrine_Pager对象执行包含适当LIMIT 子句的查询，仅获取所需的记录。
If the number of tuples, calculated by using the Cartesian product, exceeds the set threshold; the NON EMPTY clause is applied to the query.
如果通过使用Cartesian产品计算的元组数超过设定的阈值，将NONempty子句应用于查询。
You can also update, delete, and query data using a FOR PORTION OF BUSINESS_TIME clause.
还可以使用一个FORPORTION OF business_time子句来更新、删除和查询数据。
A typical parameterized query USES these parameters instead of literal values, so that WHERE clause conditions can be changed at run time.
典型的参数化查询使用这些参数来代替文字值，因此where子句条件可以在运行时更改。
You may wonder why a WHERE clause appears in this query.
您可能想知道，为什么这个查询中出现了一个WHERE 子句。
In addition, AS correlation specifications in the FROM clause can declare temporary names for columns within the query.
此外，from子句中的AS相关性规范可以为查询中的列声明临时名称。
DB2 accesses the historical data automatically and transparently only if the FROM clause of the query includes the period specifications.
只有在查询的from子句包含周期规范时，DB 2才会自动且透明地访问历史数据。
应用推荐