Article

MySQL统计每年每种类型的总数

sql 复制代码
SELECT LEFT( time, 4 ), sum( column ) FROM yourTableName GROUP BY type, LEFT ( time, 4 )
评论
0 条评论