当使用聚合函数时,默认情况下,汇总信息包含所有指定的行。
When you use an aggregate function, by default the summary information includes all specified rows.
在多于一个栏位的情况下不能使用聚合函数来对一个表的行进行分组。
F. You can not group by the rows of a table by more than one column while using aggregate functions.
如果一个度量引用其他度量,那么在为它产生SQL表达式时,不能使用聚合函数来为嵌套的度量产生SQL表达式。
When generating SQL expressions for measures that reference other measures, the aggregation function might not be used to form the SQL expression for the nested measures.
与计数函数类似,当在一个规则中使用多个具有分组关键字的聚合,对分组与计数操作必须进行级联,如图14所示。
Like the counting function, when several aggregations with grouping keys are used in a rule, the group and count operations must be cascaded as shown in figure 14.
但是,如果使用具有相同分组关键字的多个聚合,或者对相同列进行计数的计数函数,其不会显著增加规则的执行时间。
But if you use multiple aggregations with the same grouping keys, or multiple counting functions that count the same column, it will not significantly increase the execution time of the rule.
然后我可以使用内置的聚合函数来获取过期天数的大小和总和并计算平均值。
I can then use built-in aggregate functions on the array to get the size and sum of those days overdue and compute an average.
不要使用不带聚合函数的“GROUPBY”子句。
Don't use the GROUP BY clause without an aggregate function.
这个示例指示板需要数据才能完成特定的功能,所以接受了使用doc()函数由data.xq生成的聚合数据,并将结果保存在 $data变量内
The example dashboard needs data to do anything, so it brings in aggregated data generated by data.xq using the doc() function, saving the results into a $data variable
如果一个视图具有reduce函数,就使用它来聚合结果。
If a view has a reduce function, it is used to aggregate the results.
记录数量将使用Cognos聚合函数计算。
The number of records will be computed by using Cognos aggregation functions.
如果您想要使用触发器、聚合函数、外部联接、视图以及其他SQL功能,HSQLB都可以满足您的需要(大部分轻量级关系数据库无法做到这一点)。
If you want triggers, aggregated functions, outer joins, views, and other SQL features, they are all there (something you won't get from most lightweight relational databases).
每个维必须使用来自度量对象的一个聚合函数进行聚合。
Each dimension must be aggregated using one aggregation function from the measure object.
先使用度量的聚合列表中的第一个聚合函数(在这个示例中是SUM)对表达式模板进行聚合,产生一个查询。
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.
该library函数将使用在清单10 中看到的 get_services 函数检索聚合服务,然后遍历服务。
This library function uses the get_services function we saw in Listing 10 to retrieve the aggregate services. It then iterates over the services.
所以,即使数据列不是GROUPBY子句的一部分或者不包含在聚合函数中,也可以在 WHERE 子句中使用它。
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.
提供有关如何使用LINQ包含聚合函数来确定从查询返回的数据的最小值和最大值的示例。
Provides examples of how to include aggregate functions to determine the minimum and maximum values of data returned from a query by using LINQ.
可将聚合函数同其他表达式组合使用,以计算其他汇总值。
You can combine aggregate functions with other expressions to calculate other summary values.
可将聚合函数同其他表达式组合使用,以计算其他汇总值。
You can combine aggregate functions with other expressions to calculate other summary values.
应用推荐