In the sample below, the WHERE clause USES?
在下面的样本中，where子句使用？
Specify the query predicate (WHERE clause).
指定查询谓词(where子句)。
Avoid using NOT in predicate in the WHERE clause.
在WHERE子句中避免使用“NOTIN”谓词。
The WHERE clause for this finder is fairly simple.
这个查找器的where子句相当简单。
The added where clause is pretty easy to understand.
这里添加的where子句很容易理解。
You may wonder why a WHERE clause appears in this query.
您可能想知道，为什么这个查询中出现了一个WHERE 子句。
It shows four variations of its where clause in Table 1.
表1中演示了其where语句的四种变化。
Note that a parameter marker is used in the WHERE clause.
注意where子句中使用了参数标记。
You simply add the appropriate WHERE clause to the SQL query.
只需将合适的where子句添加到SQL查询中即可。
If no WHERE clause is included, all rows in the table are deleted.
如果没有包括任何where子句，则删除表中的所有行。
Not specifying key values in the WHERE clause of an SQL statement.
在SQL语句的WHERE子句里没有指定键值
The query has a WHERE clause that will only fetch the most recent values.
这个查询有一个WHERE 子句，用于过滤出最近的值。
This update does not use an SQL WHERE clause to select a specific row.
这个更新并不使用SQLwhere子句选择特定的一行。
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子句中。
You can perform a number of different Boolean operations within a WHERE clause.
可以在where子句中执行许多不同的布尔操作。
In such a scenario, the connector executes a SELECT statement with a WHERE clause.
在这种场景中，连接器执行带有where子句的SELECT语句。
The WHERE clause joins the transient and persistent XML data based on asset names.
WHERE 子句基于资产名称联接临时和永久XML数据。
To do this, you create an appropriate WHERE clause that identifies all rows of interest.
为此，创建一个适当的where子句来标识所有相关行。
But with EMPNO listed in the WHERE clause, DB2 will dutifully retrieve that column, too.
但在where子句中列出了EMPNO,DB 2还会尽职地检索该列。
For example, Listing 7 contains three comment lines with an additional WHERE clause.
比如，清单7包含了带有一个额外的where子句的三个注释行。
It is interesting to note how the WHERE clause preceded the recursive specification.
令人感兴趣的是，where子句在递归说明之前。
Include WHERE clause predicates for only the columns that are important and relevant to us.
在重要的、与我们相关的列中包含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子句应用于每条记录。
The query finds statements in the graph for which all of the triples in the WHERE clause hold.
查询在具有WHERE子句中的所有三元组的图形中查找语句。
The query finds statements in the graph for which all of the triples in the WHERE clause hold.
查询在具有WHERE子句中的所有三元组的图形中查找语句。
应用推荐