select JBDM,COUNT(*) FROM(
select JBDM from think_table union all
select JBDM1 from think_table union all
select JBDM2 from think_table ) AS B
Where JBDM <> ''
GROUP BY JBDM
ORDER BY count(*) desc
LIMIT 10 最佳答案
select JBDM,COUNT(*) FROM(
select JBDM from think_table union all
select JBDM1 from think_table union all
select JBDM2 from think_table ) AS B
Where JBDM <> ''
GROUP BY JBDM
ORDER BY count(*) desc
LIMIT 10