在WHERE子句的函数中避免封装过滤列。
Avoid wrapping filtering columns within a function in the WHERE clause.
分区键应该由常用于GROUPBY子句的列组成。
The partitioning key should be made up of columns that often participate in a GROUP BY clause.
包含where子句的能力：程序允许您基于条件对行进行限制。
Ability to include a WHERE clause: the program allows you to restrict the rows based on conditions.
还可在merge语句中using 子句的内部使用视图。
You can also use views inside the using clause of the merge statement.
含有value子句的任意数据项将在此时被初始化为一个适当的值。
Any data items that have value clauses are initialized to the appropriate value at that time.
在这种场景中，连接器执行带有where子句的SELECT语句。
In such a scenario, the connector executes a SELECT statement with a WHERE clause.
delete语句从指定表中删除满足可选where子句的所有行。
The delete statement deletes all rows from the specified table that satisfy an optional WHERE clause.
在某些情况下，“copy”子句的灵活性确实能够提供方便。
There can be situations where it's really handy to have the flexibility of the copy clause.
用法：该参数控制何时向查询MDX应用NONempty子句的决策。
Usage: This parameter controls the decision on when the NON EMPTY clause is applied to the query MDX.
可以使用标量子查询选择将用于where子句的表达式中的特定值。
You can use a scalar subquery to select a specific value that will be used in the expression of the WHERE clause.
不过这有可能会非常低效——我们希望WHERE子句的计算更接近数据端。
But this is likely to be very inefficient - we would rather the WHERE clause be evaluated closer to the data.
现在支持使用LIMIT和OFFSET 子句的新SQL语法。
New SQL syntax using the LIMIT and OFFSET clauses is now supported.
仅当when子句的计算结果为真时，触发器语句的操作部分才会执行。
Only if the WHEN clause evaluates to true will the action part of trigger statement be executed.
来自维、事实和多维数据集模型的联结对象用来形成where子句的联结谓词。
The join objects from the dimensions, facts, and cube model are used to form the join predicates of the WHERE clause.
对于通过CONNECTBY子句的迭代生成的所有行，LEVEL增加1。
For all rows produced by the iterations of the CONNECT by clause LEVEL is raised by 1.
可以把这个函数看作相当于带WHERE 子句的SQLSELECT语句。
Think of this function as the equivalent to an SQL SELECT statement with a WHERE clause.
由于该子句的逻辑跟前一场景中给出的逻辑非常类似，我们这里就不再复习它了。
Since the logic of this clause is very similar to the logic presented in previous scenarios, we won't review it again here.
对于仅包含更新子句或删除子句的merge语句，内部联接会在源表与目标表之间执行。
For the merge statement that contains only the update clause or the delete clause, the inner join is performed between source and target table.
该值应该是一个字符串，在查询表时，希望将该字符串添加到where子句的后面。
The value should be a string that you want to be added to the end of the where-clause when querying the table.
MTK现在提供对转换Oracle table_compression 子句的支持。
MTK now provides support for translating the Oracle table_compression clause.
NONempty子句的应用将查询从返回所有成员修改为仅返回具有度量值的那些成员。
The application of the NON EMPTY clause, alters the query from returning all members, to just returning those that have measure values.
如果出现了SQL 0449错误，大多数时候是因为EXTERNALname子句的格式无效。
If you get a SQL0449 error, most of the time it is because your EXTERNAL NAME clause is not in a valid format.
FinderHelper接口由包含容器将要使用的SQLwhere子句的字符串组成。
The FinderHelper interface is made up of strings that contain the SQL WHERE clauses to be used by the container.
将为每个包含linage子句的FD条目生成一个LINAGE - COUNTER专用寄存器。
A separate LINAGE-COUNTER special register is generated for each FD entry that contains a LINAGE clause.
用法：当元组数超过设定的阈值时，该参数控制是否对成员请求应用NONempty子句的决策。
Usage: This parameter controls the decision on whether or not to apply a NON EMPTY clause on member requests when the number of tuples exceeds the set threshold.
我们的下一个例子，如图2所示，是一个含有ORDERBY子句的查询，它使用了下面的代码。
Our next example, shown in Figure 2, is a query with an ORDER BY clause using the code below.
清单11还显示Zorba对XQuerywhere子句的支持，它通常用于过滤结果集的输出。
Listing 11 also demonstrates Zorba's support for the XQuery where clause, which is commonly used to filter the output result set.
对于包含JOIN操作或复杂的where子句的sql长语句(可能包含几行语句)，这一点特别有用。
This is especially helpful for long SQL statements that include JOIN operations or complex WHERE clauses that might wrap over several lines.
包含周期子句的UPDATE意味着，从value1到value2的时间段内的所有行必须更新。
The update with period clause implies that all rows between the time period from value1 to value2 must be updated.
相反，可使用具有where子句的虚拟表，或者将连接作为数据源的视图进行定义，并在这一视图中执行规则。
Instead, use a virtual table with a WHERE clause, or define the join as a view in the data source, and execute the rule on this view.
应用推荐