GroupByBehavior 枚举
定义
指定 GROUP BY 子句中的列与 SELECT 语句的选择列表中的非聚合列之间的关系。Specifies the relationship between the columns in a GROUP BY clause and the non-aggregated columns in the select-list of a SELECT statement.
public enum class GroupByBehavior
public enum GroupByBehavior
type GroupByBehavior =
Public Enum GroupByBehavior
- 继承
字段
| ExactMatch | 4 | GROUP BY 子句必须包含选择列表中的所有非聚合列,而且不能包含不在选择列表中的其他列。The GROUP BY clause must contain all nonaggregated columns in the select list, and must not contain other columns not in the select list. |
| MustContainAll | 3 | GROUP BY 子句必须包含选择列表中的所有非聚合列,而且可以包含不在选择列表中的其他列。The GROUP BY clause must contain all nonaggregated columns in the select list, and can contain other columns not in the select list. |
| NotSupported | 1 | 不支持 GROUP BY 子句。The GROUP BY clause is not supported. |
| Unknown | 0 | 对 GROUP BY 子句的支持尚不清楚。The support for the GROUP BY clause is unknown. |
| Unrelated | 2 | GROUP BY 子句中的列与 SELECT 列表中的非聚合列之间不存在关系。There is no relationship between the columns in the GROUP BY clause and the nonaggregated columns in the SELECT list. 可按任何列分组。You may group by any column. |
注解
这些 GroupByBehavior 值是相互排斥的。The GroupByBehavior values are mutually exclusive.