GroupByBehavior 列舉

定義

指定 GROUP BY 子句中的資料行與 SELECT 陳述式 (Statement) 之 SELECT 清單中非彙總 (Non-aggregated) 資料行之間的關聯性 (Relationship)。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 子句必須包含 SELECT 清單中的所有非彙總資料行,且不可以包含其他不在 SELECT 清單中的資料行。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 子句必須包含 SELECT 清單中的所有非彙總資料行,且可以包含其他不在 SELECT 清單中的資料行。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.

適用於

另請參閱