max count混合使用

SELECT MAX(a1.人数) FROM (SELECT COUNT(category_id) AS "人数",category_id FROM course_category_course  category WHERE
	category.course_id IN ('ZZZ-050','00000021','00306') GROUP BY category_id) a1;

  获取最大种类

posted @ 2019-12-05 14:45  八英里  阅读(618)  评论(0编辑  收藏  举报