Another useful aggregate function is distinct.
另一个有用的聚合函数是distinct。
Select the appropriate aggregate function.
选择适当的聚合函数。
The LISTAGG aggregate function is now supported.
现在支持LISTAGG聚合函数。
Change the aggregate function of the column to Total.
将这个列的聚合函数改为Total。
Don't use the GROUP BY clause without an aggregate function.
不要使用不带聚合函数的“GROUPBY”子句。
This paper presents a method of query of tables by using aggregate function in SQL.
介绍了在SQL中用聚合函数实现多表查询的一种方法。
To execute this command the current user must be the owner of the aggregate function.
执行这条命令的用户必须是该聚集函数的所有者。
SQL Multipart Incorrect Syntax, Aggregate Function, Multipart Identifier can not be bound.
多个SQL语法错误，聚合函数，多个标识符可以不被束缚。
When you use an aggregate function, by default the summary information includes all specified rows.
当使用聚合函数时，默认情况下，汇总信息包含所有指定的行。
If you want a column to be aggregated instead, you can specify an aggregate function for that column.
如果希望对某列进行聚合，则可为该列指定聚合函数。
The aggregate function, COUNT, is applied to the records that remain after the stage-2 predicate filtering.
作为聚合功能的COUNT适用于在阶段2谓词过滤以后保留的记录。
Columns are not automatically added to the GROUP BY clause if they are already part of an aggregate function.
如果列已经是聚合函数的一部分，则不会自动添加到GROUPby子句中。
The specified aggregate function is performed on all the values of column-1 since the last break point for column-2.
将会为column - 2执行指定的聚合功能，该聚合功能针对column - 1从上一个断点以来的所有值。
This paper presents a very efficient method, referred to as the aggregate function method, for solving nonlinear equations.
本文给出了求解非线性方程组问题的一种有效方法，称为凝聚函数法。
The next example shows how you can retrieve the value for the aggregate function max for the salary column from the EMPLOYEE table
下面这个例子展示了如何为一个聚合函数max从EMPLOYEE 表中检索salary的值
Objective to analyse the various risk factors of CHD and investigate the association with aggregate function of platelet in CHD patients.
目的探讨冠心病的各种危险因素及与血小板聚集功能的相关性。
Therefore, you can use a data column in a WHERE clause even if it is not part of the GROUP BY clause or contained in an aggregate function.
所以，即使数据列不是GROUPBY子句的一部分或者不包含在聚合函数中，也可以在 WHERE 子句中使用它。
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.
因此，必须从查询输出中移除剩余的列，或使它们成为GROUPBY子句或聚合函数的一部分。
When you choose the GROUP BY option or add an aggregate function to a query, all columns marked for output or used for sorting are automatically added to the GROUP BY clause.
当选择“分组依据”选项或将聚合函数添加到查询中时，所有标记为输出或用于排序的列将自动添加到GROUP by子句中。
By using a smooth aggregate function to approximate the non-smooth max-type function, nonlinear complementarity problem can be treated as a family of parameterized smooth equations.
利用凝聚函数一致逼近非光滑极大值函数的性质，将非线性互补问题转化为参数化光滑方程组。
To display the number of job applications containing a skill, change the aggregate function of the ID columns by selecting the ID columns of the crosstab (select the headers, not the rows below).
要显示包含某项技能的职位申请的数量，选择cross选项卡的id列(不是选择标题，而是选择标题下方的列)，修改id列的聚合函数。
When you move to a cell in this column and select an aggregate function to apply to the associated data column, by default the resulting expression is added as an output column for the result set.
当移动到该列的一个单元格中，并选择一个聚合函数应用到关联的数据列时，在默认情况下得到的表达式将作为结果集的输出列而添加进来。
If you manually add a query output column to an aggregate function in either the Criteria or SQL pane, the query and View Designer does not automatically remove other output columns from the query.
如果在“条件”窗格或“SQL”窗格中手动向聚合函数添加查询输出列，则查询和视图设计器不能自动从查询中移除其他输出列。
This binary string is comprised of the usual counter, which is needed for the DB2 MAX function to do the actual aggregation, the identifier for the aggregate object, and the group identifier.
这个二进制串由常用的计数器(DB 2max函数进行实际聚集计算时需要)、聚集对象的标识以及分组标识构成。
Start by generating the query using the first aggregation function (SUM in the example) in the measure's list of aggregations to aggregate the template expression.
先使用度量的聚合列表中的第一个聚合函数(在这个示例中是SUM)对表达式模板进行聚合，产生一个查询。
You can also aggregate strings from a sequence of strings: the new string-join function takes a sequence as an argument, unlike concat , which takes many arguments, each being a string.
还可以通过各字符串的序列来聚合字符串，新增的string - join函数以序列为参数，这与concat有所不同，它可以有很多参数，每个参数要求是字符串。
If a view has a reduce function, it is used to aggregate the results.
如果一个视图具有reduce函数，就使用它来聚合结果。
It then checks to see if the aggregate check-box is selected, and if so it applies the aggregateResults function to the selected series.
然后，它会查看是否选择了聚集复选框，如果是，则它会对已选择的系列应用aggregateresults函数。
This library function uses the get_services function we saw in Listing 10 to retrieve the aggregate services. It then iterates over the services.
该library函数将使用在清单10 中看到的 get_services 函数检索聚合服务，然后遍历服务。
The third argument, rereduce, has to do with whether or not this reduce function is operating on aggregate information or the raw results from the map (the ones from the map function).
第三个参数是rereduce，这个参数必须处理这个reduce函数是在汇总信息上操作还是在来自映射的原始结果（来自map 函数的结果）上操作。
应用推荐