The added where clause is pretty easy to understand.
这里添加的where子句很容易理解。
It shows four variations of its where clause in Table 1.
表1中演示了其where语句的四种变化。
Note: This is the equivalent to adding a where clause in a SQL SELECT statement.
注意:这相当于在SQLselect语句中增加一个where子句。
You then create the query (in other words, the where clause) and execute the update.
然后我们创建这个查询(换言之,where子句)并执行更新。
Include and instantiate the posts model, create a where clause and run a standard delete query.
包括并实例化posts模型,创建where子句并运行标准的delete查询。
Note: This is equivalent to selecting a database column in the where clause of a SQL statement.
注意:这相当于在sql语句的where子句中选择一个数据库列。
Just create the indexes and add the where clause to your SQL select statements, and you are good to go.
只需创建索引并在SQLselect语句中添加where子句,就会使用索引。
The where clause contains a small path expression that navigates from each address to its nested zip element.
where 子句包含一个小型的路径表达式,该表达式从每个地址向下定位到其内嵌的zip 元素。
The where clause is true (and the address is retained) only if the value of this zip element is equal to 95116.
只有当这个zip元素等于95116时,where子句才为true(相应的地址被保留)。
Then, the where clause essentially joins CDs with their artists with this line: where $cd/artist/$id = $artist/$id.
其次,where 子句使用 where $cd/artist/$id = $artist/$id连接了CD和艺术家。
The XQuery where clause contains the join condition, comparing the manager names with the employee name elements.
XQuery的where子句包含连接条件,这些条件用于主管姓名与员工姓名元素的比较。
The XQuery where clause can consist of nested expressions of arbitrary complexity that can even include function calls.
XQuerywhere子句可以包含任意复杂的嵌套表达式,甚至可以包含函数调用。
Each FLWR expression has one or more for clause, one or more let clause, an optional where clause, and a return clause.
每个FLWR表达式都有一个或多个for子句、一个或多个let子句、一个可选的where子句以及一个return子句。
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子句相当简单。
You may wonder why a WHERE clause appears in this query.
您可能想知道,为什么这个查询中出现了一个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查询中即可。
Not specifying key values in the WHERE clause of an SQL statement.
在SQL语句的WHERE子句里没有指定键值
If no WHERE clause is included, all rows in the table are deleted.
如果没有包括任何where子句,则删除表中的所有行。
This update does not use an SQL WHERE clause to select a specific row.
这个更新并不使用SQLwhere子句选择特定的一行。
Avoid wrapping filtering columns within a function in the WHERE clause.
在WHERE子句的函数中避免封装过滤列。
The query has a WHERE clause that will only fetch the most recent values.
这个查询有一个WHERE 子句,用于过滤出最近的值。
The columns in the WHERE clause decide what index the database will select.
WHERE子句中的字段决定了数据库将选择的索引。
A simpler syntax is generated when ROWNUM is specified in the WHERE clause.
当在where子句中指定ROWNUM时,可生成更简单的语法。
Add a WHERE clause to limit the number of rows to test the movement of data.
添加where子句以限制转移的数据行数。
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子句中执行许多不同的布尔操作。
You can perform a number of different Boolean operations within a WHERE clause.
可以在where子句中执行许多不同的布尔操作。
应用推荐