mysql - SQL分组并按最大字段获取行

Question

我有下表:

  T1 | T2 | T3
  ------------
  A  | 2  | XY
  A  | 1  | XA
  A  | 4  | XZ
  B  | 2  | XF
  C  | 3  | XA
  C  | 7  | XY
  D  | 1  | XL
  D  | 2  | XF
  E  | 3  | XA
  E  | 6  | XZ
  E  | 2  | XY
  F  | 3  | XL
  F  | 2  | XZ

我正在尝试按 T1 分组并在同一 MAX(T2) 行中获取 MAX(T2) 和 T3；如果没有其他选择，我怎么能得到它？

Answer 1

SELECT * FROM table outertable
INNER JOIN (
    SELECT t1, MAX(t2) as `mx` FROM table GROUP BY t1
) innertable ON outertable.t1 = innertable.t1 AND outertable.t2 = innertable.mx