select DATE_FORMAT(time,'%Y-%m') yue,COUNT(*) number from Visit where doctorId=1 group by DATE_FORMAT(time,"%Y-%m")
把数据库表还有time换成自己的就行。
select DATE_FORMAT(time,'%Y-%m') yue,COUNT(*) number from Visit where doctorId=1 group by DATE_FORMAT(time,"%Y-%m")
把数据库表还有time换成自己的就行。