Mapping subquery and aggregate functions
映射子查询和聚合功能
A third method is to have the summary tables rebuilt after the ETL process using SQL sum and aggregate functions.
第三种方法是在ETL流程之后使用SQLSUM和汇总函数来重构汇总表。
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.
然后我可以使用内置的聚合函数来获取过期天数的大小和总和并计算平均值。
The statistical view currently does not support aggregate functions like SUM, MAX, distinct operations or set operation like UNION, EXCEPT or INTERSECT.
当前，统计视图不支持SUM、max之类的聚合函数，也不支持distinct操作和UNION、EXCEPT或INTERSECT之类的集合操作。
Can also be used to apply aggregate functions to each group.
还可以用于将聚合函数应用于每个组。
They differ from aggregate functions in that they return multiple rows for each group.
与集合函数不同，他们返回各分组的多行记录。
You can combine aggregate functions with other expressions to calculate other summary values.
可将聚合函数同其他表达式组合使用，以计算其他汇总值。
You can use custom expressions in place of aggregate functions anywhere in an aggregate query.
您可以使用自订运算式取代汇总查询中任何位置的汇总函式。
You can also specify aggregate functions to apply to the grouped elements from the second collection.
您还可以指定要应用到第二个集合中的分组元素的聚合函数。
In addition to using aggregate functions to aggregate data, you can create custom expressions to produce aggregate values.
除了使用汇总函式汇总资料以外，您也可以建立自订运算式产生汇总值。
Provides examples of how to include aggregate functions to determine the minimum and maximum values of data returned from a query by using LINQ.
提供有关如何使用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.
提供有关如何使用LINQ包含聚合函数来确定从查询返回的数据的最小值和最大值的示例。
应用推荐