您可以使用
group by和进行操作
having：
select u.username, count(s.id) as total_subscribersfrom users as uinner join subscribers as s on s.suid = u.uidgroup by u.idhaving count(s.id) > 0
您可以使用
group by和进行操作
having：
select u.username, count(s.id) as total_subscribersfrom users as uinner join subscribers as s on s.suid = u.uidgroup by u.idhaving count(s.id) > 0
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
