Since the column contains a "1" for every deviating record and "0" for non-deviating records, you need to add the values of the column.
对于每个偏差记录,这个列的值为“1”,对于非偏差列,这个列的值为“0”,因此,需要添加这个列的值。
In a subsequent data flow operation, you'll use a join operator to ensure that full XML account records (contained in the INFO column) are fed into the target data warehouse table.
在随后的数据流操作中,您将使用一个连接操作符确保整个XML账户记录(包含在info列中)被填充到目标数据仓库表中。
The amount of each order is computed by summing the amount column of the associated details records.
每项订单的数量都通过加总相关详细信息记录的列计算得出。
If updates to the coordinate columns are possible, you may still be able to avoid bulk copies if the source table contains a time stamp column that records the time of last update for each row.
如果可能更新坐标列,但是源表包含一个时间戳列,其中记录了每行最后一次更新的时间,那么仍然可以避免批量复制。
In this column, I'll show you how to create partitioned tables, and I'll show you how a partitioned table's definition determines where individual records are stored.
在这篇专栏文章中,我将讨论如何创建分区表,解释分区表的定义如何决定各个记录的存储位置。
There may be scenarios where you would like to do some computations on sets of records broken based on particular column values, but would not like to print that column in the report.
可能有些情况,您想要对根据特定的列值分割的记录集进行一些计算,但是不希望在报表中打印该列。
If a report needs to be broken into separate sets of records based on a particular column value, then you can use the BREAK command.
如果需要根据某个特定的列值将报表分成多个记录集,那么您可以使用BREAK命令。
The break command can be used to break the report into a set of records based on a particular column value.
BREAK命令可用于基于特定列值将报表分成一组记录。
For example, all the values for SALE_QUANTITY column are between 1 and 10, with approximately 10% of the records having each of the 10 distinct values.
例如,SALE _ QUANTITY列中的所有值都是处于1到10之间,约10%的记录具有各不相同的值。
Figure 24 defines the column to be used as the key to check the duplicate records.
图24定义了列,用作检查重复记录的键。
The patient records contain a column that indicates whether they have one of the four heart diseases (y = yes) or not (n = no).
病人的记录中有一个列表明他们是否患有四种心脏病之一,y 表示是,n 表示否。
As we discussed earlier, our sample DB2 table contains different versions of FpML records in a single column, and we're only interested in a specific FpML 4.7 record.
正如我们前面所讨论过的,我们的样例DB 2表在单个列中包含FpML记录的不同版本,但是我们只关心特定的FpML 4.7记录。
In addition to the differences mentioned so far, Oracle supports storing VARRAYs as a column type, and supports the creation of arrays of records and arrays of arrays.
除了到目前为止讲述的差异外,Oracle还支持存储VARRAY作为列类型,并支持创建记录的阵列和阵列的阵列。
The queries are simple with good performance because you need not do any joins to access multiple subclasses, and ActiveRecord can use the type column to determine which records to return.
这些查询简单且性能很好,因为您无需进行任何连接来访问多个子类,ActiveRecord可以使用type列决定哪个记录能够返回。
The above error can occur if the Sybase existing table definition declares one of the columns to be NOT NULL but there is no value for that column in one of the records of the result set.
如果sybase现有表定义声明某一列为NOT NULL,但是在结果集中的某一行记录在那一列没有值,就可能发生上述错误。
The Customer ID column is used to show the number of customer records per profession.
CustomerID列用于显示每种职业客户记录的数量。
For example, SYSIBM.SYSCOLAUTH, which details column-level privileges, is a child of SYSIBM.SYSTABAUTH, which records table-level privileges.
例如,SYSIBM . SYSCOLAUTH包含列级权限的详细信息,它是SYSIBM .SYSTABAUTH的子表,后者记录了表级权限。
The OutlierFlag column is used to show the number of deviating records per profession.
OutlierFlag 列用于显示每种职业偏差记录的数量。
Logical records: The columns in a table are accessed through column names, not record offsets.
逻辑记录:表中的列是通过列名而非记录偏移量来访问的。
Records can be sorted by clicking the column header.
记录能通过点击标题栏进行归类。
The records can be grouped by drag-and-drop, or sorted by clicking on the column header.
这些记录可以通过拖放或点击标题栏的方式归类。
For example, if you specify two columns, the records are sorted first on the first column named and then on the second column named.
例如,如果指定两列,则首先对第一个命名列的记录进行排序,然后对第二个命名列的记录进行排序。
The default value is assigned in the column as new rows (records) are created.
当创建新行(记录)时默认值即被分配到列中。
The column names returned in the records must be unique, otherwise columns with duplicate names overwrite previous data.
在资料录中传回的资料行名称必须是唯一的,否则具有重复名称的资料行会覆写先前的资料。
The column names returned in the records must be unique, otherwise columns with duplicate names overwrite previous data.
在资料录中传回的资料行名称必须是唯一的,否则具有重复名称的资料行会覆写先前的资料。
应用推荐