select count( distinct name),sum(money),time from tb group time
select count(*),sum(money),str_to_date(time,'%Y-%m') as timeline from csdn_wus group by timeline
如果数据库里time字段存储的类型为varchar就用上面的语句,如果是date类型就用date_format()转换:select count(*),sum(money),date_format(time,'%Y-%m') as timeline from <tbl_name> group by timeline
from tb
group time
from tb
group by time
我已解决了,是group_concat(name),取出再用程序给删除重复的值
from tb
group time
select count(*),sum(money),str_to_date(time,'%Y-%m') as timeline from csdn_wus group by timeline