Or, if you'd like only certain rows to be replicated, you just use a WHERE clause in your query.
或者,如果只希望复制表的某些行,那么只需要在查询中使用where子句。
The columns in the WHERE clause decide what index the database will select.
WHERE子句中的字段决定了数据库将选择的索引。
To do this, you create an appropriate WHERE clause that identifies all rows of interest.
为此,创建一个适当的where子句来标识所有相关行。
Include WHERE clause predicates for only the columns that are important and relevant to us.
在重要的、与我们相关的列中包含where子句谓词。
The query finds statements in the graph for which all of the triples in the WHERE clause hold.
查询在具有WHERE子句中的所有三元组的图形中查找语句。
The delete statement deletes all rows from the specified table that satisfy an optional WHERE clause.
delete语句从指定表中删除满足可选where子句的所有行。
The query has a WHERE clause that will only fetch the most recent values.
这个查询有一个WHERE 子句,用于过滤出最近的值。
But with EMPNO listed in the WHERE clause, DB2 will dutifully retrieve that column, too.
但在where子句中列出了EMPNO,DB 2还会尽职地检索该列。
The WHERE clause restricts the search to so-called hetero atoms and only considers the first model of each protein.
where子句将搜索限制在了所谓的异质原子并且只考虑了每种蛋白质的第一个模型。
In the sample below, the WHERE clause USES?
在下面的样本中,where子句使用?
Deterministic function calls can be extracted from the WHERE clause to avoid unnecessary table scan.
可以从WHERE子句中提取确定性函数调用,避免不必要的表扫描。
In addition, our sample query qualifies the rows of interest by specifying relational and XML predicates in the WHERE clause.
此外,我们的样例查询通过在where子句中指定关系谓词和xml谓词,限定了所关注的行。
You may wonder why a WHERE clause appears in this query.
您可能想知道,为什么这个查询中出现了一个WHERE 子句。
The unchanged fields are not used in the WHERE clause, since these fields are not updated in the first place.
没有修改的域未用在WHERE 子句中,这是因为这些域都不是在首先进行更新的。
Tables can be joined either explicitly, by using the JOIN keyword, or implicitly, by using a WHERE clause.
表可以通过使用JOIN关键字显式地连接,也可以通过使用WHERE 子句隐式地连接。
If the data provider is an SQL database, the WHERE clause must be applied to each record.
如果数据提供程序是一个SQL数据库,则必须将where子句应用于每条记录。
However, the container will append a WHERE clause anyway, so we need to supply a valid predicate.
但是,无论如何容器将来还是要附加一个where子句,所以我们需要提供一个有效的谓词。
For example, Listing 7 contains three comment lines with an additional WHERE clause.
比如,清单7包含了带有一个额外的where子句的三个注释行。
You simply add the appropriate WHERE clause to the SQL query.
只需将合适的where子句添加到SQL查询中即可。
The SQL WHERE clause indicates that we want only results related to credit default trades.
SQLwhere子句表明,我们只想要与信用违约交易相关的结果。
If no WHERE clause is included, all rows in the table are deleted.
如果没有包括任何where子句,则删除表中的所有行。
This tutorial describes subqueries stated as conditions in the WHERE clause, which are useful for simpler comparison queries.
本教程描述在 WHERE 子句中作为条件的子查询,这些子查询对于较简单的比较查询很有用。
For example, changing the ordering of the where clause statement to improve performance helps in certain databases.
例如,更改某些子句的排序可以帮助提高某些数据库的性能。
The query needed to create the index would change to include this new column in the WHERE clause.
创建索引所需的查询将发生变化以在where子句中包括这个新列。
In such a scenario, the connector executes a SELECT statement with a WHERE clause.
在这种场景中,连接器执行带有where子句的SELECT语句。
This function cannot appear in a DELETE statement's WHERE clause. It is only allowed in queries.
这个函数不能出现在delete语句的where子句中,而只能出现在查询中。
Ability to include a WHERE clause: the program allows you to restrict the rows based on conditions.
包含where子句的能力:程序允许您基于条件对行进行限制。
The WHERE clause for this finder is fairly simple.
这个查找器的where子句相当简单。
You can perform a number of different Boolean operations within a WHERE clause.
可以在where子句中执行许多不同的布尔操作。
The WHERE clause joins the transient and persistent XML data based on asset names.
WHERE 子句基于资产名称联接临时和永久XML数据。
应用推荐