直接使用max()函数，就会取最大值啊

SELECT age_group 年龄组 FROM (SELECT CASE WHEN age <= 64 THEN \'64以下\' WHEN age >= 65 AND age <= 70 THEN \'65-70\' WHEN age >= 71 AND age <= 75 THEN \'71-75\' WHEN age >= 76 AND age <= 80 THEN \'76-80\' WHEN age >= 81 AND age <= 85 THEN \'81-85\' WHEN age >= 86 THEN \'85以上\' END AS age_group, CASE WHEN sex = 1 THEN \'男\' END AS male, CASE WHEN sex = 2 THEN \'女\' END AS female FROM (SELECT per.sex, TIMESTAMPDIFF(YEAR, per.birthday, CURDATE()) AS age FROM t_health_check ck LEFT JOIN t_person per ON ck.person_id = per.id WHERE ck.del_flag = 0 AND per.del_flag = 0 AND ck.org_id = \'${orgId}\' AND ck.year = \'${ckYear}\') a) b GROUP BY age_group ORDER BY ORDER BY total_number DESC LIMIT 1

值所在行任意单元格设置条件属性，行高为0，公式设定rank(g3,g3[!0],0)>1  或者 rank(d3,dd3[!0],0)>1

test1.cpt