2条回答 默认 最新
- 我哎开发 2016-12-09 07:18关注
select count(1) as '当日即缴费的用户数量' from user a
inner join meter b on a.id=b.userId
and DATE_FORMAT(a.time, '%Y-%m-%d')=DATE_FORMAT(b.time, '%Y-%m-%d')根据业务,如果缴费信息表有注册当天多次缴费,就先去重:
select count(1) as '当日即缴费的用户数量' from user a
inner join (select userId,min(time) as time from meter group by userId) b on a.id=b.userId
and DATE_FORMAT(a.time, '%Y-%m-%d')=DATE_FORMAT(b.time, '%Y-%m-%d')本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报