扫码关注官方订阅号
欢迎选择我的课程，让我们一起见证您的进步~~
select count(author_id) as num from (select author_id,created from posts GROUP BY author_id HAVING count(id)=1) as t where t.created BETWEEN '2016-09-020 00:00:00' and '2016-09-20 23:59:59';
嗯，这个问题....
难道不是按照时间排序就可以了吗？
select min(issue_date) md ,user_id from table group by user_id where md = '9.20'
微信扫码关注PHP中文网服务号
QQ扫码加入技术交流群
Copyright 2014-2026 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
PHP学习
技术支持
返回顶部
0 
3
693
收藏
select count(author_id) as num from (select author_id,created from posts GROUP BY author_id HAVING count(id)=1) as t where t.created BETWEEN '2016-09-020 00:00:00' and '2016-09-20 23:59:59';
嗯，这个问题....
难道不是按照时间排序就可以了吗？