為什么執(zhí)行這條 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)
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
舉報
2017-11-07
實(shí)際就是兩條數(shù)據(jù)