这可以通过使用数据行中包含的时间戳或序列号来进行，也可将数据行的每个列字段添加到UPDATE的where子句中。
This can be done by using a timestamp or sequence number contained in the row, or by adding every column in the row to the WHERE clause of the UPDATE.
只需将合适的where子句添加到SQL查询中即可。
You simply add the appropriate WHERE clause to the SQL query.
我们将调用EDIT命令，并在顺序中指定语句序号2，通过这些操作给上面的select语句添加where子句。
Let's add a WHERE clause to that SELECT statement by invoking the EDIT command and specifying statement number 2 in the sequence.
在多个线程中卸载同一个表不需要其他设置，只需要添加where子句。
There is no other setup required to unload the same table in multiple threads, except to add different WHERE clause as explained.
如果将ALLOWWRITEACCESS子句添加到每个导入命令中，则可以运行并行导入会话。
You can run parallel import sessions, if you add the ALLOW WRITE ACCESS clause to each import command.
一个where子句被添加到一个select语句字符串，该字符串表示R PGCHAIN操作中使用的键字段对应的一列或多列。
A WHERE clause is added to the Select statement string representing the column or columns that correspond to the key fields used in the RPG CHAIN operation.
这里添加的where子句很容易理解。
提供的解决方案非常简单：给else子句添加一个额外的if语句。
The solution provided is remarkably simple: you add an extra if statement to the else clause.
可以通过在teller类和ImproperDepositException之间添加另一个调用箭头来为else子句建模。
The else clause would be modeled by adding another call arrow between the Teller class and the ImproperDepositException.
清单7定义一个序列名，然后使用一个for子句遍历该序列，获取每个名称并将其添加到节点集合中。
Listing 7 defines a sequence of names, and then USES a for clause to loop through this sequence, retrieving each name and adding it to a node collection.
一个FOR FETCHonly子句被添加到select语句，以避免记录锁定并利用SQL自动块操作的优势。
A FOR FETCH ONLY clause is added to the Select statement to avoid record locking and to take advantage of SQL automatic blocking.
编辑生成的sql脚本，对于标记的事实表添加COMPRESSyes子句到CREATEtable语句。
Edit the generated SQL script adding the COMPRESS YES clause to the CREATE table statement for the noted fact tables.
单击ok将其自动添加到uses子句中。
如果通过添加order BY子句按提取的city值排序，那么结果集仍然是相同的：paris、paris和paris被当作相同的值。
If you add an order by clause, to order by the extracted city value, the result set still remains the same: Paris, Paris, and Paris are treated as the same value.
该值应该是一个字符串，在查询表时，希望将该字符串添加到where子句的后面。
The value should be a string that you want to be added to the end of the where-clause when querying the table.
创建触发器(在when子句中添加对全局变量的检查)。
Create the trigger (add checking for the global variable in the WHEN clause).
添加一个ORDERSIBLINGSBY子句，该子句只能与分级查询子句组合使用，并且将按预先定义的顺序返回同级查询结果。
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.
在下一个示例中，会修改以前的查询，添加一个ORDERBYsiblings子句，从按照NAME排序的结果中获取同级查询结果。
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.
与此同时，还可以尝试向WHERE子句中添加额外的谓语来匹配其他WHERE子句。
In the meantime, you also should try to add extra predicates into your WHERE clause to match other WHERE clauses.
要获取所有级别上的所有下属，必须将PRIOR运算符添加到分级查询子句的CONNECTBY部分。
To get all subordinates over all levels, the PRIOR operator must be added to the CONNECT BY part of the hierarchical query clause.
惟一需要注意的其他事项是，可以、也应该在CREATETABLE语句后面添加一个子句，以指定将表放在哪个数据库中。
The only other noticeable difference is that an additional clause can and should be appended to the CREATE TABLE statement to specify in which database the table shall be placed.
例如，只需在列出监控表函数返回的应用程序数据的查询中添加where子句，就可以搜索CPU消耗量最大的应用程序。
For example, you can easily search for the applications consuming the highest amount of CPU by simply adding a WHERE clause to a query that lists application data from a monitoring table function.
为了便于比较，图3显示了通过将SELECTIVITY1子句添加到where子句的谓词中，强迫db2优化器忽略索引的访问计划。
For comparison, Figure 3 illustrates the access plan where I forced the DB2 optimizer to ignore the index by adding the clause SELECTIVITY 1 to the predicate in the where clause.
添加where子句以限制转移的数据行数。
Add a WHERE clause to limit the number of rows to test the movement of data.
因为职员id存储在id列中，所以很容易通过在sql语句的where子句中添加范围比较来实现这个筛选器。
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.
在这里，只是添加了一条order子句。
为了实现这种集群，在清单3中的第二个CREATEtable语句添加如下子句：organizeBYDIMENSIONS (label_comp _ id)。
To achieve this clustering, add the following clause to the second CREATE TABLE statement in Listing 3: ORGANIZE BY DIMENSIONS (label_comp_id).
从DB 2 9.5往后，您就可以向xml索引定义添加可选的REJECTINVALIDvalues子句。
Since DB2 9.5 you can add the optional clause REJECT INVALID VALUES to your XML index definition.
只需创建索引并在SQLselect语句中添加where子句，就会使用索引。
Just create the indexes and add the where clause to your SQL select statements, and you are good to go.
例如，在Oracle中可以添加rownum子句以限制行数，对于SQLServer使用top子句。
For example, you can add a ROWNUM clause to limit the number of rows in Oracle or use the TOP clause for SQL Server.
应用推荐