sql语句

按年分组统计

select date_format(列名, '%Y') `year`, COUNT(*) count from 表名 group by date_format(列名, '%Y');