為啥要用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
提交
取消
2018-12-12
關(guān)聯(lián)查詢