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
继承
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.

适用于

另请参阅