对Mysql不太熟,最近有项目需要用到分组统计的功能,MSSQL中有 grouping with rollup搭配,可以很方便的找到哪行是 合计、小计、总计,但mysql中 没有grouping函数,不知道该怎么区分 哪行是汇总值,哪行是普通数值,请问有谁知道Mysql中该如何实现的方法麻烦告知下,多谢 多谢!MsSql 示意select grouping(area_code)as sets,area_code,bill_month,sum(local_fare) local_fare
from t
group by rollup(area_code,bill_month)sets AREA_CODE BILL_MONTH LOCAL_FARE---------- --------------- --------------0 5761 200405 13060433.890 5761 200406 13318931.010 5761 200407 13710265.930 5761 200408 14135782.211 5761 合计 54225413.04
from t
group by rollup(area_code,bill_month)sets AREA_CODE BILL_MONTH LOCAL_FARE---------- --------------- --------------0 5761 200405 13060433.890 5761 200406 13318931.010 5761 200407 13710265.930 5761 200408 14135782.211 5761 合计 54225413.04
IFNULL(area_code,'')试试
OR
用
UNION ALL
SELECT '合计,SUM() FROM ....
UNION ALL
SELECT '小计,SUM() FROM ....