为啥要用where 在c.user_id=b.user_id
SELECT
u.username,
uk.timer,
uk.kills
FROM
`user` u
JOIN user_kills uk ON u.id = uk.user_id
GROUP BY u.username HAVING uk.kills=max(uk.kills)
这样也行也能得出来为啥要用where 在c.user_id=b.user_id
qq_d_134
2018-12-06
1 回答
举报
0/150
提交
取消
