mysql 区分或分组依据

Question

SELECT DISTINCT(player2) FROM logs 
WHERE player1=3 
ORDER BY time DESC

是否可以通过该查询返回其他非不同列？

或者我的其他解决方案:

SELECT * FROM logs 
WHERE player1=3 
GROUP BY player2 ORDER BY time DESC

这工作正常，但没有正确排序。它选择组中的第一个。

表格示例:

player1 player2 time
3        5        1
3        5        2
3        6        3

我希望它返回:

player2 time
5        2
6        3

但它返回(使用分组依据):

player2 time
5        1
6        3

Answer 1

试试这个:

SELECT player2, MAX(time) AS time
  FROM logs 
 WHERE player1=3 
 GROUP BY player2 
 ORDER BY time DESC