SQLSERVER 分组数

SQL server，

获取 table_name 表中基于 group_column 列进行分组后的分组数量
SELECT COUNT(*) AS num_groups
FROM (
    SELECT group_column
    FROM table_name
    GROUP BY group_column
) AS subquery;

获取大分组分了几组数据，分组条件

SELECT
    COUNT(*) OVER (PARTITION BY group_column2) AS num_groups
    , ROW_NUMBER() OVER ( 
        PARTITION BY
            group_column2 
        ORDER BY
            group_column2
    ) AS row_num
    , group_column 
FROM
    (SELECT DISTINCT group_column FROM table_name) AS subquery 

row_num = 1