SQL 查询:查找评论电影数量最多的用户名
SELECT user_name FROM comments GROUP BY user_name HAVING COUNT() = (SELECT COUNT() FROM comments GROUP BY user_name ORDER BY COUNT(*) DESC LIMIT 1) ORDER BY user_name ASC LIMIT 1
原文地址: https://www.cveoy.top/t/topic/qoxr 著作权归作者所有。请勿转载和采集!