Aggregate query in a distributed environment.
分布式环境内的聚集查询。
Currently, Slice can evaluate an aggregate query correctly that is not commutative to partition.
目前，Slice可以正确地估计一个聚集查询，不是分区可互换的。
You can use custom expressions in place of aggregate functions anywhere in an aggregate query.
您可以使用自订运算式取代汇总查询中任何位置的汇总函式。
The following principles describe how you can reference columns in an aggregate query in search conditions.
下列原则描述如何在聚合查询的搜索条件中引用列。
Thus, most of the principles that follow describe the ways that you can reference individual data columns within an aggregate query.
因此，其他的原则即说明在汇总查询中参考个别资料行的方法。
If you want to create subtotals or show other summary information for subsets of a table, you create groups using an aggregate query.
如果要创建小计或显示表的子集的其他汇总信息，可使用聚合查询创建组。
Group By column of the grid is not displayed (because you have not yet specified an aggregate query), the search condition is placed into the WHERE clause.
“分组依据”列(因为尚未指定聚合查询)，则搜索条件将被放入where子句中。
To reduce the expensive access to archive data, the characteristics of aggregate data query were analyzed, and the aggregate query language and its rewriting method were proposed.
为了减少在计算和存档数据流的过程中对昂贵的存档数据的存取，分析了聚集数据查询的特点，并引入了聚集查询语言和聚集查询重写方法。
In this paper, We propose a kind of novel aggregate query algorithms based on hardware-software codesign, which incorporate hardware advantage in processing rate and software long suit in agility.
提出了一种基于硬件加速的高速数据流聚集查询方法，充分发挥硬件在处理速度上的优势和软件在灵活性方面的长处。
This paper researches into the characteristic of aggregate query rewriting and gives a kind of rapidly approximate query computing model based on aggregate query rewriting under the data warehouse.
研究了聚集查询重写的特征，根据数据仓库环境下聚集查询需要快速计算结果的特点，给出了一个基于聚集查询重写的快速近似计算模型。
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)对表达式模板进行聚合，产生一个查询。
Ability to join, union, aggregate, and otherwise correlate data from multiple sources in a single query.
在一个查询中连接、联合、聚集来自多个数据源的数据并使它们相关的能力。
An MQT can be used to enhance query performance through the pre-computation of aggregate values. For example.
MQT可用于通过预先计算聚合值来增强查询性能。
Consider an example query that finds the aggregate sales of all the beauty products sold in the US that are also sold in Europe.
考虑如下示例查询，该查询用于发现所有同时在美国和欧洲销售的美容产品的总销售量。
The query to compute aggregate sales by city can be written as
按城市计算总销售的查询可以写成
We discovered that there is a point where aggregate index costs—more-expensive INSERT and DELETE operations, for example—outweigh a new index's query speed-up benefit.
我发现有一个聚合索引成本的点 —例如，更为昂贵的INSERT和DELETE操作 —超出一个新索引的查询加速所能带来的效益。
Once the MQT is created and populated, when a user submits a query to find aggregate sales or its variant information, it may be satisfied by using the aggregate_sales MQT.
一旦MQT 已经创建并填充好，当用户提交一个查询以找到总销售数据或变体信息时，就会通过使用 aggregate_sales MQT 来满足该查询。
A smart OLAP cube will realize when you should use an aggregate and re-write your query to use the aggregated data instead.
一个聪明的OLAP多维数据集将实现时，你应该使用一个聚合和重写你的查询，而不是使用汇总数据。
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包含聚合函数来确定从查询返回的数据的最小值和最大值的示例。
This paper deals with two ways to manage aggregate queries: materialized view and approximate query, concludes the processing methods of each way and presents future research directions.
讨论了目前聚集查询处理的两种方法，即实化视图和近似查询，总结了国内外对其研究现状，并对未来的研究方向提出看法。
This paper presents a method of query of tables by using aggregate function in SQL.
介绍了在SQL中用聚合函数实现多表查询的一种方法。
Also developed for the PRA tree is an enhanced predictive range aggregate (EPRA) query algorithm which USES a more precise branch and bound searching strategy, reducing the disk I?
提出了一种增强预测范围聚集查询epra算法，采用更精确的剪枝搜索准则，减少了查询所需要访问的节点代价。
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子句中。
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”窗格中手动向聚合函数添加查询输出列，则查询和视图设计器不能自动从查询中移除其他输出列。
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子句或聚合函数的一部分。
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子句或聚合函数的一部分。
应用推荐