以下是引用tlliqi在2015-12-9 20:00:26的发言:
sele bmd,SUM(dla级) dla级,SUM(dlb级) dlb级,SUM(dlc级) dlc级,SUM(dld级) dld级,SUM(dle级) dle级 from 表 grou by bmd
茅塞顿开
sele bmd,SUM(dla级) dla级,SUM(dlb级) dlb级,SUM(dlc级) dlc级,SUM(dld级) dld级,SUM(dle级) dle级 from 表 grou by bmd