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”谓词。
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子句里没有指定键值
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子句中。
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子句在递归说明之前。
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 SQL WHERE clause indicates that we want only results related to credit default trades.
SQLwhere子句表明,我们只想要与信用违约交易相关的结果。
Additional predicates added to a complex WHERE clause, containing OR, and, and parentheses.
添加到复杂的where语句的额外谓词,包括OR、AND和括号。
Or, if you'd like only certain rows to be replicated, you just use a WHERE clause in your query.
或者,如果只希望复制表的某些行,那么只需要在查询中使用where子句。
This function cannot appear in a DELETE statement's WHERE clause. It is only allowed in queries.
这个函数不能出现在delete语句的where子句中,而只能出现在查询中。
The delete statement deletes all rows from the specified table that satisfy an optional WHERE clause.
delete语句从指定表中删除满足可选where子句的所有行。
The delete statement deletes all rows from the specified table that satisfy an optional WHERE clause.
delete语句从指定表中删除满足可选where子句的所有行。
应用推荐