Mapping subquery and aggregate functions
映射子查询和聚合功能
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.
您可以使用自订运算式取代汇总查询中任何位置的汇总函式。
F. You can not group by the rows of a table by more than one column while using aggregate functions.
在多于一个栏位的情况下不能使用聚合函数来对一个表的行进行分组。
E. You can use aggregate functions on a table, only by grouping the whole table as one single group.
在将整个表分为一个组的情况下可以对表进行聚合。
You can also specify aggregate functions to apply to the grouped elements from the second collection.
您还可以指定要应用到第二个集合中的分组元素的聚合函数。
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.
然后我可以使用内置的聚合函数来获取过期天数的大小和总和并计算平均值。
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包含聚合函数来确定从查询返回的数据的最小值和最大值的示例。
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之类的集合操作。
Each of the aggregation functions used to aggregate the measure value along with the dimensions specified for the aggregation.
用来对度量值进行聚合的每个聚合函数都指定了对应的维。
The role of the data-movement functions is shown in Figure 4 as it relates to the types involved for copy (simple vs. aggregate).
当数据移动函数的规则涉及到复制调用的类型时(简单VS.聚集),这些函数的作用如图4 所示。
The new smart sensor has the functions of both smart elements and the normal aggregate in concrete materials and can be used to solve problems caused by the combination of two materials.
它既是混凝土结构健康监测的智能元件,又具有普通骨料的功能,很好地解决了压电传感器与主体结构相结合时出现的各种实际问题。
Profiling Tools reports aggregate the total values of the functions in the profiling session itself, and the processes, threads, and binaries of the session.
分析工具报告聚合分析会话本身以及会话的进程、线程和二进制文件中函数的总值。
This paper analyzes the demanding determinants of consumer goods theoretically, establishes rural, urban sales functions respectively, and then integrates them into a sales aggregate model of China.
本文在理论分析的基础上,提出需求实现的决定因素,分别建立农村、城镇消费品零售量函数,再总合为全国消费品零售量模型。
This paper analyzes the demanding determinants of consumer goods theoretically, establishes rural, urban sales functions respectively, and then integrates them into a sales aggregate model of China.
本文在理论分析的基础上,提出需求实现的决定因素,分别建立农村、城镇消费品零售量函数,再总合为全国消费品零售量模型。
应用推荐