sql统计分组的组数
SELECT COUNT(*) from (SELECT * from enroll GROUP BY org_id) newtable;
例子
查询攻击的类别数
SELECT "count"(*) from (SELECT event_type from internal_app_bsackc."event" group by event_type) as a;
声明：该文观点仅代表作者本人，牛骨文系教育信息发布平台，牛骨文仅提供信息存储空间服务。
SELECT COUNT(*) from (SELECT * from enroll GROUP BY org_id) newtable;
例子
查询攻击的类别数
SELECT "count"(*) from (SELECT event_type from internal_app_bsackc."event" group by event_type) as a;
