2018年8月13日
mysql分组统计以及全部统计union all使用
摘要： select '全部' AS `organ_category`, COUNT(*) AS amount FROM `organ_new` WHERE `city_code` ='SZ0755' AND `organ_type` ='P' AND `state` ='1' union all select `organ_category` ,COUNT(1) AS `amount` ... 阅读全文
posted @ 2018-08-13 18:02 宇枫 阅读(3089) 评论(0) 推荐(0) 编辑