為什么要多列（b.user_id, b.kills）？只用過濾b.kills就可以了呀？
SELECT a.user_name, b.timestr, b.kills FROM user1 a JOIN user_kills b ON a.id = b.user_id WHERE b.kills IN (SELECT MAX(kills) cnt FROM user_kills GROUP BY user_id);
3 回答
舉報
0/150
提交
取消
SELECT a.user_name, b.timestr, b.kills FROM user1 a JOIN user_kills b ON a.id = b.user_id WHERE b.kills IN (SELECT MAX(kills) cnt FROM user_kills GROUP BY user_id);
2017-03-10
舉報
2022-03-30
2018-09-29
+1--? 之過濾這一個? 沒出現過錯誤數據的情況呀
2017-03-15
必須要過濾兩個列，當不同的人有相同的殺怪數的時候，只過濾kills會產生好多錯誤數據