在多个mysql连接中根据最近的条目获取和排序-Getandorderbasedonmostrecententrywhileinmultiplemysqljoins

0  

In stead of trying to figure out how to satisfy your needs in current query, wouldn't it be an option to create a separate table, let's say "Handicaps_latest", which only stores player_id and required info of latest review. The reason for doing this is because you are only trying to get(columns in your select clause) the information about players and nothing really needed from handicaps table. In this case, a handicaps table with multiple entries per player might not be a good table to join. But considering that those data might be required in other logic, so leave them there and create a branch new table only storing latest review data could be an option for your case. But it requires some extra work apparently, that is, whenever you insert a new entry into your original handicpas table, a particular entry in handicaps_latest needs to be updated.

不是试图弄清楚如何在当前查询中满足您的需求,而是创建一个单独的表不是一个选项,让我们说“Handicaps_latest”,它只存储player_id和最新评论的必需信息。这样做的原因是因为你只是试图获得(在你的select子句中的列)关于玩家的信息,而不是障碍表中真正需要的东西。在这种情况下,每个玩家有多个条目的障碍表可能不是一个很好的加入表。但考虑到其他逻辑可能需要这些数据,因此请将它们留在那里并创建一个分支新表,只存储最新的审查数据可能是您的案例的一个选项。但它显然需要一些额外的工作,也就是说,无论何时你在原始的障碍表中插入一个新的条目,都需要更新handicaps_latest中的特定条目。

0  

SELECT x.*
  FROM my_table x
  JOIN 
     ( SELECT id,MAX(other_column) max_other_column FROM my_table GROUP BY id) y
    ON y.id = x.id
   AND y.max_other_column = x.other_column;