【slq】查询所有机构中投诉最多的数据，对两个字段进行分组

 

单条公司数据如下

 

对所有数据分组查询

SELECT
	branch_id,
	branch_name,
	case_cause,
	count( 1 ) 
FROM
	lr_opewarn_judgedoc a 
WHERE
	case_cause = (
	SELECT
		case_cause 
	FROM
		lr_opewarn_judgedoc b 
	WHERE
		a.branch_id = b.branch_id 
	GROUP BY
		branch_id,
		case_cause 
	ORDER BY
		COUNT( * ) DESC 
		LIMIT 1 
	) 
GROUP BY
	branch_id ORDER BY
	branch_name DESC;