The second major function performed by a WHERE clause is to join multiple tables together into a single table that can be queried more easily.
WHERE 子句执行的第二个主要功能是将多个表连接到单个表中，从而更易于查询。
In this window you will find the mapping of columns, and you will have the option to restrict the data that will be replicated in case this is a requirement, using a WHERE clause or row filters.
在这个窗口中，您将发现列的映射，并且如果需要，可以使用where子句或者行过滤器来限制要复制的数据。
Update 2 is an SQL SELECT statement with the same XMLQUERY function, transform expression, and WHERE clause, as in Update 1.
更新2是一个SQLselect语句，其中包含与更新1相同的XMLQUERY函数、转换表达式和where子句。
In case you have not set the DB2DBDFT environment variable, all Net Search Extender administrative tasks require the connect to clause, where is the name of your database.
如果还没有设置DB2DBDFT环境变量，那么所有NetSearchExtender管理任务都需要connect to子句，其中的是数据库的名称。
But we're not done yet. If the data provider is an SQL database, the WHERE clause must be applied to each record.
事情还没有完结，如果数据提供者是一个SQL数据库的话，WHERE子句必须应用在每条记录上。
If the data provider is an SQL database, the WHERE clause must be applied to each record.
如果数据提供程序是一个SQL数据库，则必须将where子句应用于每条记录。
This is due to the semantics of SQL: without a WHERE clause, SQL queries do not filter out any rows from the table in the returned result set.
这是由于SQL的语义导致的：没有了where子句，SQL查询就不会在返回的结果集中过滤掉表中的任何行。
If no WHERE clause is included, all rows in the table are deleted.
如果没有包括任何where子句，则删除表中的所有行。
IF/THEN/ELSE logic is fertile ground for figuring out how to use WHERE clause predicates so rows can be rejected sooner in DB2's address space.
IF/THEN/ELSE逻辑是搞清楚如何使用WHERE 子句谓词的良好基础，因此在DB2 地址空间中行能够被快速拒绝。
Include WHERE clause predicates for every column on the row to see if each column value is the same as its original value.
在行的每个列中包含where子句谓词，来确定每列的值是否与其初始值相同。
A more efficient technique is to filter database rows by placing conditions in the WHERE clause, which is evaluated immediately after the tables are specified within the FROM clause.
更有效的方法是通过在where子句中放置条件来过滤数据库行，在from子句中指定表之后会立即对where子句求值。
But this is likely to be very inefficient - we would rather the WHERE clause be evaluated closer to the data.
不过这有可能会非常低效——我们希望WHERE子句的计算更接近数据端。
This function cannot appear in a DELETE statement's WHERE clause. It is only allowed in queries.
这个函数不能出现在delete语句的where子句中，而只能出现在查询中。
But a disadvantage in this case is that the compilation of SELECT (the creation of the access plan) occurs before the values for the predicates in the WHERE clause are bound.
但这种方法存在一个缺点，在绑定where子句中谓词的值之前，需要编译SELECT(创建访问计划)。
The simplest and most common use of the WHERE clause is to filter the rows from a table before selecting any columns, as demonstrated in Listing 4.
WHERE 子句最简单最常见的用法是在选择任意列之前过滤表中的行，如 清单 4 所示。
The WHERE clause for this finder is fairly simple.
这个查找器的where子句相当简单。
Update 3 also USES a second parameter marker in the WHERE clause to select the row that is updated.
更新3在where子句中使用第二个参数标志来选择要更新的行。
The Data Protection Act, which normally prevents companies from sharing such information, has a get-out clause for cases where it is clear that a crime has been committed.
而一般会防止公司透露这类信息的《数据保护法案》针对犯罪事实清楚的情况规定了特例条款。
There is no other setup required to unload the same table in multiple threads, except to add different WHERE clause as explained.
在多个线程中卸载同一个表不需要其他设置，只需要添加where子句。
A simpler syntax is generated when ROWNUM is specified in the WHERE clause.
当在where子句中指定ROWNUM时，可生成更简单的语法。
It is interesting to note how the WHERE clause preceded the recursive specification.
令人感兴趣的是，where子句在递归说明之前。
This statement is then completed by the row specifying the test condition, which is also used to populate the FROM clause and additional the WHERE clause so forming a predicate.
再加上指定测试条件的行，该语句就完整了，指定测试条件的行用来组成from子句以组成谓语。
Note that a parameter marker is used in the WHERE clause.
注意where子句中使用了参数标记。
DATAFILES is a mandatory clause for each external table. It specifies the file path where the data can be read from or written to.
DATAFILES是每个外部表的必需子句，它指定读写数据的文件路径。
This SQL is better than simply reading all the data without the WHERE clause and then checking each row to see if the SALARY is greater than 50000.00 in your program.
与只读取所有数据而不使用WHERE 子句，然后在程序中检查SALARY是否大于 50000.00的做法相比，该SQL更好。
It should be noted that there are situations where the for UPDATE clause is not available for a given SELECT statement.
需要注意的是，在某些情况下给定的select语句不能使用FOR update子句。
My response to this top 10 question is: Rearranging WHERE clause predicates may be an exercise in futility.
我对这个前十大问题的回答是：重新安排where子句谓词可能是无用功。
The SQL WHERE clause further restricts the target XML documents to those found only in rows in which the client's "status" is of a certain value (" Silver, "in this method).
SQLwhere子句进一步将目标XML文档限制为只在这样的行中找到的文档，这些行中客户的“status ”是一个确定值(在本例中是“Silver ”)。
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属性匹配，后者是显示记录的关键字段。
A common mistake for most Hibernate developers is to create a new index whenever they need a new WHERE clause.
大多数Hibernate开发者所常犯的一个错误是无论何时，当需要新WHERE子句的时候都会创建一个新的索引。
应用推荐