• 分区键应该由常用于GROUPBY子句的列组成。

    The partitioning key should be made up of columns that often participate in a GROUP BY clause.

    youdao

  • 星型数据库的事实表中join子句中的列。

    Columns in the join clauses in fact table of star schema database.

    youdao

  • 指定生成的GROUPBY子句中包括的列,如图13所示。

    Specify the columns to be included in the generated GROUP BY clause, as shown in Figure 13.

    youdao

  • 创建索引所需的查询将发生变化以在where子句中包括这个新列。

    The query needed to create the index would change to include this new column in the WHERE clause.

    youdao

  • 可在ORDERBY 子句中使用伪列LEVEL按照搜索宽度优先顺序返回结果集。

    The pseudo column LEVEL can be used in the ORDER BY clause to return the result set in search breadth first sequence.

    youdao

  • 因此,您常常可以选择实现只包括在WHERE和ORDERBY子句中引用到的列的索引。

    Therefore, you may often choose to implement indexes that include only the columns referred to in the WHERE and ORDER BY clauses.

    youdao

  • SELECT子句含有来自表中的所有列(完全行复制)

    The SELECT clause has all the columns from the tables (full row replication)

    youdao

  • 例如,在前面的查询中,XMLExists的passing子句不需要指定custxml列。

    For example, in the previous query the XMLExists passing clause does not specify the CUSTXML column.

    youdao

  • 类似于在常规的ORDERby子句中,可以按升序或降序指定多个列。

    Like in a regular ORDER BY clause multiple columns can be specified in either ascending or descending sequence.

    youdao

  • 如果表的主键或惟一性约束中指定了这个列,那么不允许使用这个子句(SQLSTATE 42831)。

    This clause is not allowed if the column is specified in the primary key, or in a unique constraint of the table (SQLSTATE 42831).

    youdao

  • WHERE 子句最简单最常见的用法是在选择任意列之前过滤表中的行,如 清单4 所示。

    The simplest and most common use of the WHERE clause is to filter the rows from a table before selecting any columns, as demonstrated in Listing 4.

    youdao

  • WITH ORDINALITY子句使UNNEST生成另一个整数类型的列,包含与每一个元素关联的位置。

    The WITH ORDINALITY clause causes UNNEST to generate an additional column of type integer that contains the position associated with each element.

    youdao

  • 注意:这相当于在sql语句的where子句中选择一个数据库列。

    Note: This is equivalent to selecting a database column in the where clause of a SQL statement.

    youdao

  • 在MEDIUM模式的显式的UPDATESTATISTICS操作中,resolution子句中新的SAMPLINGSIZE选项可以指定列分布进行抽样的最少行数。

    In explicit UPDATE STATISTICS operations in MEDIUM mode, a new SAMPLING SIZE option in the Resolution clause can specify the minimum number of rows to sample for column distributions.

    youdao

  • 指定列的行用来组成SQLselect语句的select、FROM和ORDERBY子句。

    The row specifying the column is used to populate the select, FROM and ORDER BY clauses of the SQL select statement.

    youdao

  • 对于select子句中的xmlquery函数,默认情况下传递purchaseorder表的porder列。

    For the xmlquery function in the SELECT clause, the porder column of the purchaseorder table is passed by default.

    youdao

  • 定义了列的查询元素表中的行顺序决定了它们在ORDERBY子句中从左到右的顺序,这又确定了它们的排序优先级。

    The row order in the query elements table in which columns are defined determines their left to right sequence within the order BY clause, which in turn determines their sorting priority.

    youdao

  • 使用预测子句可以说明如何使用预测列。

    Use a prediction clause to describe how the prediction column is used.

    youdao

  • 因此,必须从查询输出中移除剩余的列,或使它们成为GROUPBY子句或聚合函数的一部分。

    Therefore, you must remove the remaining columns from the query output or make them part of the GROUP BY clause or of an aggregate function.

    youdao

  • 如果尝试将contains子句用于不具有当前活动的全文索引的列,则将收到错误。

    If you attempt to use the CONTAINS clause on a column that does not have a currently active full-text index, you will receive an error.

    youdao

  • 首先,在索引中包括WHERE子句中的所有列,这样,就可以使用索引形成的屏蔽来拒绝结果集中不合格的行。

    First, include in the index all the columns in the WHERE clause, so that index screening can be used to reject unqualified rows from the result set.

    youdao

  • 通过BLOB数据类型或使用FORBITdata子句定义的列将以二进制形式从源传递到目标,所使用的代码页是零。

    Columns defined with the BLOB data type, or using the FOR BIT data clause will be passed as binary from the source to the target, and the code page used is zero.

    youdao

  • 在DB 2 9.7中,只需通过CREATEtable语句的COMPRESSyes子句启用XML数据的压缩功能,这会同时压缩表中的关系和xml列。

    In DB2 9.7, the compression capability for XML data is enabled simply through the compress YES clause of the CREATE table statement, which compresses both relational and XML columns in the table.

    youdao

  • 第一行是一个SQL子句,指定仅检索 "clients"表 "name"列中的信息。

    The first line is an SQL clause specifying that you only want to retrieve information in the "name" column of the "clients" table.

    youdao

  • values子句还为用户指定的oid列的值包括了一个casting函数,因为该值必须强制转换成目标表的REFERENCE类型。

    The VALUES clause also includes a casting function for the user-specified value of the OID column because the value must be cast into the REFERENCE type of the target table.

    youdao

  • orderbyposteddesc子句强迫此查询按posted列中的日期(即文章发布到Web站点的日期)的降序返回行。

    The order by posted desc clause forces the query to return rows in descending order by the date in the posted column (which is the date that the article was posted on the Web site).

    youdao

  • 还可以看到“set”子句给xml列“info”设置一个新值,这个新值是一个XMLQUERY函数的结果。

    You also see that the "set" clause assigns a new value to the XML column "info", and that this new value is the result of an XMLQUERY function.

    youdao

  • 当在RUNSTATS中指定LIKEstatistics子句时,将收集附加的列统计信息。

    When the LIKE statistics clause is specified in RUNSTATS, additional column statistics are collected.

    youdao

  • 因为xml列不能参与groupBy子句,所以需要定义第二个XML RelationalMapping操作符(图1中上方的分支)。

    Because XML columns cannot participate in Group By clauses, you need to define a second XML Relational Mapping operator (shown on the upper branch of Figure 1).

    youdao

  • 因为xml列不能参与groupBy子句,所以需要定义第二个XML RelationalMapping操作符(图1中上方的分支)。

    Because XML columns cannot participate in Group By clauses, you need to define a second XML Relational Mapping operator (shown on the upper branch of Figure 1).

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定