避免重复行。
I'd like to prevent duplicate rows.
我想防止重复行。
Explains how to filter duplicate rows out of Select queries.
说明如何利用选取查询来筛选重复的资料列。
If you have duplicate rows in your table, they will not be returned as distinct.
如果在你的表中有重复的记录,那么它们将不会作为不同的的记录返回。
Respectively, be achieved using arrays and linked the file to remove duplicate rows.
分别用数组和链表方式实现去除文件中的重复行。
A primary key is a constraint that assures that each table contains no duplicate rows.
主键是确保每个表都不包含重复行的约束。
Recall that clients were defined with a primary key on the client ID column, so attempting to import duplicate rows will fail.
记得clients对客户ID列定义了一个主键,因此在尝试导入相同行时将失败。
You can use the --extratargetrows option with either of these three options: keep, delete, and merge to specify how to handle duplicate rows.
可以使用 --extratargetrows选项,加上keep、delete和merge这三个选项中的一个,来规定如何处理重复行。
When having duplicate rows in the lock table (see the Create a DB2 table for resource locking section), concurrent use of the resource is possible.
如果锁表中有重复的行(参见为资源锁定创建一个DB 2表一节),就可以对资源进行并发使用。
Each row of a table is uniquely identified by a primary key composed of one or more columns. This implies that a table may not contain duplicate rows.
表的每一行都是由一个唯一的主键标识的。主键由一列或多列构成。这意味表里不会有重复的行。
It is a good practice to delete any pruned rows from the table that you loaded in order to ensure that you do not load duplicate rows into the table at a later time.
从您装载的表中删除被修剪过的行,确保以后不会将重复的行装载到表中,这是一种很好的做法。
However, if there are many duplicate rows per distinct index value, and the associated table is highly clustered, the added costs of joining through the index can be slight.
然而,如果每个不同的索引值都有许多重复的行,而所关联的表是高度群集的,那么通过索引添加的连接成本可能很低。
However, if the session data conflicts with a new index, (such as duplicate rows conflicting with a unique index), the index is not materialized for that session until the data is corrected.
但是,如果会话数据与某个新索引冲突(比如重复行在唯一的索引上冲突),则在数据纠正之前不会为该会话物化该索引。
Some of the information in these rows is either duplicate or irrelevant for inventory projection.
在这些行中,有些信息是重复的,或者与库存反映无关。
To avoid analyzing duplicate records, you delete rows from the CHECKING table with a timestamp greater than the one you pruned the pruned the audit log with.
为了避免分析重复的记录,从checking表中删除时间戳大于一个指定的、用于修剪日志的时间戳的行。
To avoid analyzing duplicate records, you delete rows from the CHECKING table with a timestamp greater than the one you pruned the pruned the audit log with.
为了避免分析重复的记录,从checking表中删除时间戳大于一个指定的、用于修剪日志的时间戳的行。
应用推荐