In the Where do you want to export resources to?
在Wheredoyouwanttoexportresources to ？
Avoid using NOT in predicate in the WHERE clause.
在WHERE子句中避免使用“NOTIN”谓词。
Note that a parameter marker is used in the WHERE clause.
注意where子句中使用了参数标记。
Not specifying key values in the WHERE clause of an SQL statement.
在SQL语句的WHERE子句里没有指定键值
This can be useful shorthand for use in the where or return clauses.
在where或return子句中，这可能是非常有用的简写。
Avoid wrapping filtering columns within a function in the WHERE clause.
在WHERE子句的函数中避免封装过滤列。
The columns in the WHERE clause decide what index the database will select.
WHERE子句中的字段决定了数据库将选择的索引。
A simpler syntax is generated when ROWNUM is specified in the WHERE clause.
当在where子句中指定ROWNUM时，可生成更简单的语法。
These predicates can also be used in the WHERE clause of the SELECT statement.
这些谓词还可以用于select语句的where子句中。
This will enter a valid EJBQL query with one cmp-field used in the WHERE predicate.
这通过在 WHERE 语句中使用一个 cmp 字段来输入有效的EJBQL查询语句。
The result of that subquery then becomes a value in the WHERE clause expression
它的结果会成为where语句表达式中的一个值。
But with EMPNO listed in the WHERE clause, DB2 will dutifully retrieve that column, too.
但在where子句中列出了EMPNO,DB 2还会尽职地检索该列。
You can specify static queries to use variables in the WHERE clause, as shown in Listing 4.
可以让静态查询在where子句中使用变量，见清单4。
The query finds statements in the graph for which all of the triples in the WHERE clause hold.
查询在具有WHERE子句中的所有三元组的图形中查找语句。
Update 3 also USES a second parameter marker in the WHERE clause to select the row that is updated.
更新3在where子句中使用第二个参数标志来选择要更新的行。
Note: This is equivalent to selecting a database column in the where clause of a SQL statement.
注意：这相当于在sql语句的where子句中选择一个数据库列。
The query needed to create the index would change to include this new column in the WHERE clause.
创建索引所需的查询将发生变化以在where子句中包括这个新列。
The unchanged fields are not used in the WHERE clause, since these fields are not updated in the first place.
没有修改的域未用在WHERE 子句中，这是因为这些域都不是在首先进行更新的。
Two types of queries can be used in the WHERE clause of an UPDATE statement: a scalar subquery and a table subquery.
两种查询可以用于update语句的where子句中：标量子查询和表子查询。
In addition, our sample query qualifies the rows of interest by specifying relational and XML predicates in the WHERE clause.
此外，我们的样例查询通过在where子句中指定关系谓词和xml谓词，限定了所关注的行。
This tutorial describes subqueries stated as conditions in the WHERE clause, which are useful for simpler comparison queries.
本教程描述在 WHERE 子句中作为条件的子查询，这些子查询对于较简单的比较查询很有用。
It lets DB2 use the index to immediately look up the row or rows that satisfy the two simple predicates in the WHERE clause.
它让DB 2使用索引来立即查找满足where子句中的两个简单谓词的行。
Therefore, you may often choose to implement indexes that include only the columns referred to in the WHERE and ORDER BY clauses.
因此，您常常可以选择实现只包括在WHERE和ORDERBY子句中引用到的列的索引。
It can be very slow to do queries across a virtual table, especially if you use one of the TimeSeries elements in the WHERE clause.
虚表上的查询可能非常慢，尤其是在where子句中使用某个TimeSeries元素时更是如此。
With a value of Changed, only the Key fields and the original values of the fields that were changed are passed in the WHERE clause.
如果选择的值是Changed，那么只有Key域和要修改的域的原来值会传递到 WHERE 子句中。
It can be used in the WHERE clause of an SQL statement to select only the rows that return non-trivial XML values for the XPath expression.
可以在sql语句的where子句中使用它只选择那些对于XPath表达式返回非空xml值的行。
The predicate in the WHERE clause constrains the relational column office, which the view maps to the path /dept/employee/office in the XML column.
WHERE 子句中的谓词限制关系列office，而视图把这一列映射到XML 文档中的路径 /dept/employee/office。
Since the employee id is stored in the id column, this filter is easy to implement by adding a range comparison in the where clause of the SQL statement.
因为职员id存储在id列中，所以很容易通过在sql语句的where子句中添加范围比较来实现这个筛选器。
And create the following index that includes both columns referenced by predicates in the WHERE clause of the above query, separated by the SALARY column.
创建如下索引，该索引含有以上查询的where子句的谓词引用的全部两个列，由SALARY列隔开。
The parameter used in the WHERE clause to identify the working record must match the DataKeyNames property, which is the key field for the displayed records.
用于标识工作记录的where子句中使用的参数必须与DataKeyNames属性匹配，后者是显示记录的关键字段。
应用推荐