为什么执行这条 SQL 语句只能查询到 2 条记录？
select a.user_name, b.timestr, b.kills from user1 a join user_kills b on a.id = b.user_id group by a.user_name HAVING b.kills = MAX(b.kills)
1 回答
举报
0/150
提交
取消
select a.user_name, b.timestr, b.kills from user1 a join user_kills b on a.id = b.user_id group by a.user_name HAVING b.kills = MAX(b.kills)
2017-11-05
举报
