您可以使用
union all取消透视数据集，然后聚合：
select disease, count(*) totalfrom ( select disease from mytable union all select additional_disease1 from mytable union all select additional_disease2 from mytable union all select additional_disease3 from mytable union all select additional_disease4 from mytable) tgroup by diseaseorder by total desc, disease
