groupby
- 网络分组；组织表输出；分组查询
groupbygroupby
分组
DataGrid - jQuery MiniUI 1.0 Documentation ... isEditing 是否有行编辑。 groupBy 分组。比如： frozenColumns 锁定列。比如…
组织表输出
Windows PowerShell™ 用户手册 -... ... 查看对象结构( Get-Member) 组织表输出( -GroupBy) 对控制台输出进行分页( Out-Host) ...
分组查询
另外，在对分组查询（GroupBY）进行分组时，如果采用第三种方案，每一次分页都将会进行两次分组查询，非常的低效，这 …
分组操作符
... 联接操作符(join,GroupJoin)05 分组操作符(GroupBy)06 串联操作符(Concat)07 聚合操作符(Aggregate,Average,Count,Long…
子句
Oracle PL/SQL 编程手册,JAVA/AJAX... ... sum 计算总工资 groupby 子句 select 小结 ...
分组统计
...查询全体学生均匀年龄【例】查询1号课程的最高分8）分组统计（groupby）【例】查询男女学生各有多少人。
分组条件
...询属性过滤条件（attributeFilter）、分组条件（groupBy）、查询 id 数组（ids）、关联查询项数组（joinItems）、关联外部 …
建立分组统计的查询
4.1.6 建立分组统计的查询(GroupBy)
1
Indicates that the data column is being used to create a grouped result set (is part of a GROUP BY clause) in an aggregate query.
表示数据列用于在聚合查询中创建分组的结果集（GROUPBY子句的一部分）。
2
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子句中使用它。
3
One of these operators (shown on the lower branch in Figure 4) feeds a Group By operator, which performs the aggregations shown in Table 1.
其中一个操作符（图4中下方的分支）为一个GroupBy操作符提供输入，后者执行表1中所示的聚合。
4
If the associated data column is part of a GROUP BY clause, the expression you enter is used for a HAVING clause.
如果关联的数据列是GROUPBY子句的一部分，则输入的表达式用于HAVING子句。
5
A query can use an indexed view in its execution plan even if it does not satisfy these GROUP BY restrictions.
即使一个索引视图不满足这些GROUPBY限制，查询也可以在其执行计划中使用该视图。
6
Use the Group by drop-down menu on the right-side panel (Figure 21) to switch to the Folders view (if it is not the view already selected).
使用在右边面板的Groupby拉下菜单（图21）以切换到Folders视图（如果它不是目前已选择的视图）。
7
A column used in an expression of the SELECT clause must be in the GROUP BY clause.
在SELECT子句的表达式中使用的列必须位于GROUPBY子句中。
8
Using SQL group by and aggregation functions on that table is usually more efficient than producing the same result in plain XQuery.
对该表使用SQL的groupby函数和聚集函数通常比使用生成相同结果的普通XQuery更有效。
9
When used without a GROUP BY clause, aggregate functions report only one aggregate value for a SELECT statement.
如果聚合函数没有使用GROUPBY子句，则只为SELECT语句报告一个聚合值。
10
The main query does not contain a GROUP BY clause, and is not an aggregate query, or the subquery returns exactly one value.
主查询不包含GROUPBY子句并且不是汇总查询，或者子查询恰好返回一个值。
11
The GROUP BY keywords are followed by a list of columns, known as the grouping columns.
GROUPBY关键字后跟一个列的列表，称为组合列。
12
And, once we begin using the RANDOM option, we must be very careful to code both a GROUP BY and an ORDER BY when order matters.
而且，一旦我们开始使用RANDOM选项，我们必须在排序至关重要时非常小心地编写GROUPBY和ORDERBY。
13
Remember that a scalar aggregate is a single value produced by an aggregate function without a GROUP BY clause.
请记住，标量集合是由不具有GROUPBY子句的集合函数生成的单个值。
14
Specify the columns to be included in the generated GROUP BY clause, as shown in Figure 13.
指定生成的GROUPBY子句中包括的列，如图13所示。
15
The results of a standard GROUP BY with vector aggregate functions produce one row with one value per group .
具有矢量集合函数的标准GROUPBY的结果将生成一行，行中的每一个组都具有一个值。
16
An expression on a column used in the GROUP BY clause, or an expression on the results of an aggregate.
在GROUPBY子句中使用的列的表达式或基于聚合结果的表达式。
17
The result sets of SELECT statements with a GROUP BY clause and no ORDER BY clause are sorted by the GROUP BY columns.
带GROUPBY子句但不带ORDERBY子句的SELECT语句的结果集，将按GROUPBY列排序。
18
Finally, this operator extracts one relational value that drives two aggregate operations computed in a subsequent Group By operation.
最后，该操作符提取一个关系值，用于驱动随后的GroupBy操作中计算的聚合操作。
19
Grouping is allowed only in the select list associated with a GROUP BY clause that contains either the CUBE or ROLLUP operator.
仅在与包含CUBE或ROLLUP运算符的GROUPBY子句相关联的选择列表中才允许分组。
20
The GROUP BY clause restricts the rows of the result set; there is only one row for each distinct value in the grouping column or columns.
GROUPBY子句限制结果集中的行数，每个不同的值在组合列中只占一行。
21
HAVING is usually used with the GROUP BY clause.
HAVING通常与GROUPBY子句一起使用。
22
A view is deterministic if all expressions in the select list , as well as the WHERE and GROUP BY clauses, are deterministic .
如果选择列表中的所有表达式、WHERE和GROUPBY子句都具有确定性，则视图也具有确定性。
23
Do not choose Group By, Expression, or Where, because those options do not apply when you are aggregating all rows.
不要选择GroupBy、Expression或Where，因为这些选项不适用于聚合所有行。
24
If there is no GROUP BY clause, put all the rows into a single group.
如果没有GROUPBY子句，将把所有行都置于一个组中。
25
The GROUP BY clause can be used to generate results that contain aggregates for each group, but no detail rows.
GROUPBY子句可用于生成只包含各组的聚合而不包含其明细行的结果。
26
The only columns that can be used in the nonaggregate expressions are those specified as grouping columns in the GROUP BY clause.
只有在GROUPBY子句中指定为分组列的列才能用在非聚合表达式中。
27
Use the up and down arrows to scroll through the columns in the GROUP BY Columns box.
使用向上和向下箭头可滚动查看[GROUPBY列]框内的列。
28
The GROUP BY clause must contain all nonaggregated columns in the select list, and must not contain other columns not in the select list.
GROUPBY子句必须包含选择列表中的所有非聚集列，而且不能包含选择列表中没有的其他列。
29
Whenever an aggregate function is used in a SELECT statement that does not include a GROUP BY clause, it produces a single value .
只要在不包括GROUPBY子句的SELECT语句中使用集合函数，集合函数就只生成一个值。
30
V$SQL lists statistics on shared SQL area without the GROUP BY clause and contains one row for each child of the original SQL text entered.
SQL列出了再共享sql区域的统计信息的列表，不包括groupby子句，包括输入的原始sql文本的一行。