所在省份 学校名称

高中名单(总计人)

MySQL Query : SELECT COUNT(*) as count FROM (select diqu,xuexiao,sum(counts2) as counts from(SELECT diqu,xuexiao,count(xuexiao) as counts2 FROM ims_thank_teacher_form_thanksend WHERE group by xuexiao union SELECT diqu,xuexiao,count(xuexiao) as counts2 FROM ims_thank_teacher_form_thankteach WHERE group by xuexiao) temp group by xuexiao order by counts desc) T
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by xuexiao union SELECT diqu,xuexiao,count(xuexiao) as counts2 FROM ims_t' at line 1
MySQL Errno : 1064
Message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by xuexiao union SELECT diqu,xuexiao,count(xuexiao) as counts2 FROM ims_t' at line 1
Need Help?
序号 省份 学校 人数