以下是一些关于该子句的使用的例子。
在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.
清单1和清单2显示了MT K对一个范围分区子句的转换。
Listings 1 and 2 show the translation of a range partitioning clause by MTK.
包含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.
正确的答案是使用 :include子句的哈希语法。
The correct answer is to use a hash syntax for the :include clause.
在这种场景中，连接器执行带有where子句的SELECT语句。
In such a scenario, the connector executes a SELECT statement with a WHERE clause.
例如，更改某些子句的排序可以帮助提高某些数据库的性能。
For example, changing the ordering of the where clause statement to improve performance helps in certain databases.
用法：该参数控制何时向查询MDX应用NONempty子句的决策。
Usage: This parameter controls the decision on when the NON EMPTY clause is applied to the query MDX.
在某些情况下，“copy”子句的灵活性确实能够提供方便。
There can be situations where it's really handy to have the flexibility of the copy clause.
比如，清单7包含了带有一个额外的where子句的三个注释行。
For example, Listing 7 contains three comment lines with an additional WHERE clause.
现在支持使用LIMIT和OFFSET 子句的新SQL语法。
New SQL syntax using the LIMIT and OFFSET clauses is now supported.
delete语句从指定表中删除满足可选where子句的所有行。
The delete statement deletes all rows from the specified table that satisfy an optional WHERE clause.
可以使用标量子查询选择将用于where子句的表达式中的特定值。
You can use a scalar subquery to select a specific value that will be used in the expression of the WHERE clause.
仅当when子句的计算结果为真时，触发器语句的操作部分才会执行。
Only if the WHEN clause evaluates to true will the action part of trigger statement be executed.
不过这有可能会非常低效——我们希望WHERE子句的计算更接近数据端。
But this is likely to be very inefficient - we would rather the WHERE clause be evaluated closer to the data.
可以把这个函数看作相当于带WHERE 子句的SQLSELECT语句。
Think of this function as the equivalent to an SQL SELECT statement with a WHERE clause.
为了进行验证，将转换代码放入到子句的块中，并检查块中的test语句。
To validate, place the transformation code inside the block of a clause and check the condition as a test statement inside the block.
对于通过CONNECTBY子句的迭代生成的所有行，LEVEL增加1。
For all rows produced by the iterations of the CONNECT by clause LEVEL is raised by 1.
来自维、事实和多维数据集模型的联结对象用来形成where子句的联结谓词。
The join objects from the dimensions, facts, and cube model are used to form the join predicates of the 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.
清单3和清单4显示了MT K对一个table_compression子句的转换。
Listings 3 and 4 show the translations of a table_compression clause by MTK.
MTK现在提供对转换Oracle table_compression 子句的支持。
MTK now provides support for translating the Oracle table_compression clause.
这可以通过调用使用了CCSIDunicode子句的CREATEtable语句来执行。
This can be performed by invoking the CREATE TABLE statement using the CCSID UNICODE clause. For example.
对于仅包含更新子句或删除子句的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.
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.
将为每个包含linage子句的FD条目生成一个LINAGE - COUNTER专用寄存器。
A separate LINAGE-COUNTER special register is generated for each FD entry that contains a LINAGE clause.
应用推荐