mysql 本月查询

2019独角兽企业重金招聘Python工程师标准>>>

select a.nickName,b.* from qx_user a INNER JOIN
(
SELECT sum(amount),userId from qx_user_account_detail t where   DATE_FORMAT(createTime,'%Y-%m') ='2016-11'   group by userId 
) b on a.id=b.userId

转载于:https://my.oschina.net/u/1052192/blog/783962