Mysql 通过显示多行进行分组

Question

数据库结构

表“Org_f_a_list”

  id    org_id    user_id    date_added
  1          1          1      2017-01-01 05:05:05

表“用户”

  id      username      last_login
   1      Testuser     2017-01-01 05:05:05

表“Users_pa”

  id      user_id        summoner_id       rank_solo
   1            1                  1               15
   2            1                  2               17

我当前的查询

select max(rank_solo) as rank,last_login,username,o.user_id,date_added 
      from org_f_a_list o
      join users u on o.user_id = u.id 
      join users_pa as p on u.id = p.user_id
      where org_id = :org 
      group by u.id,rank_solo,date_added
      order by rank desc

我想要的结果

 user_id      user_name     rank    date_added    last_login
       1      Testuser       17           date          date

我目前的结果

   user_id     user_name    rank      date_added    last_login
         1     Testuser       15            date          date
         1     Testuser       17            date          date

出于某种原因，按 u.id 分组没有执行任何操作，我仍然拉动两行，而不仅仅是最大排名

编辑:修复了它。多谢你们!

Answer 1

从分组依据中删除rank_solo

select max(rank_solo) as rank,last_login,username,o.user_id,date_added 
from org_f_a_list o
join users u on o.user_id = u.id 
join users_pa as p on u.id = p.user_id
where org_id = :org 
group by u.id,date_added
order by rank desc