In the sample below, the WHERE clause USES?
在下面的样本中，where子句使用？
Avoid using NOT in predicate in the WHERE clause.
在WHERE子句中避免使用“NOTIN”谓词。
The WHERE clause for this finder is fairly simple.
这个查找器的where子句相当简单。
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子句里没有指定键值
The columns in the WHERE clause decide what index the database will select.
WHERE子句中的字段决定了数据库将选择的索引。
Avoid wrapping filtering columns within a function in the WHERE clause.
在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子句中。
The result of that subquery then becomes a value in the WHERE clause expression
它的结果会成为where语句表达式中的一个值。
If the WHERE clause of an SQL statement applies multiple predicates, as follows.
如果sql语句的where子句使用了多个谓词。
The WHERE clause joins the transient and persistent XML data based on asset names.
WHERE 子句基于资产名称联接临时和永久XML数据。
The WHERE clause USES DB2's XMLExists function to restrict the data to be returned.
where子句使用DB2的XMLExists函数限制查询所返回的数据。
But with EMPNO listed in the WHERE clause, DB2 will dutifully retrieve that column, too.
但在where子句中列出了EMPNO,DB 2还会尽职地检索该列。
It is interesting to note how the WHERE clause preceded the recursive specification.
令人感兴趣的是，where子句在递归说明之前。
You then create the query (in other words, the where clause) and execute the update.
然后我们创建这个查询(换言之，where子句)并执行更新。
From the WHERE clause in HQL you can usually guess the corresponding SQL WHERE clause.
从HQL的WHERE子句中通常可以猜到相应的SQL WHERE子句。
The WHERE clause also includes any predicates you may want to use to subset the results.
WHERE 子句还包含用来产生结果子集的任何谓词。
If the data provider is an SQL database, the WHERE clause must be applied to each record.
如果数据提供程序是一个SQL数据库，则必须将where子句应用于每条记录。
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子句中的所有三元组的图形中查找语句。
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子句中包括这个新列。
In Listing 3, the WHERE clause contains the user credentials as well as the post ID to be updated.
在清单3中，where子句包含用户凭据以及要更新的文章ID。
Update 3 also USES a second parameter marker in the WHERE clause to select the row that is updated.
更新3在where子句中使用第二个参数标志来选择要更新的行。
The WHERE clause restricts the update to a specific credit default swap trade involving Agrium Inc.
where子句将更新限制到一个涉及Agrium Inc .的特定信用违约掉期交易。
Deterministic function calls can be extracted from the WHERE clause to avoid unnecessary table scan.
可以从WHERE子句中提取确定性函数调用，避免不必要的表扫描。
Use the WHERE clause to filter data in the SQL instead of bringing it all into your program to filter.
在SQL中使用where子句过滤数据，而不是在程序中到处使用它进行过滤。
Finally, the WHERE clause consists of a series of triple patterns, expressed using Turtle-based syntax.
最后，where子句由一组三元模式组成，用基于Turtle的语法表示。
But this is likely to be very inefficient - we would rather the WHERE clause be evaluated closer to the data.
不过这有可能会非常低效——我们希望WHERE子句的计算更接近数据端。
应用推荐