mysql - SELECT all 并按 A 列排序，不重复 B 列，然后按 C 列排序

Question

如何选择一行中的所有列按最新的更新列排序，不重复phone列，然后按points列排序？

+----+----------+---------+------------+
| id | phone    | points  | updated    |
+----+----------+---------+------------+
| 1  | iPhone 5 | 123156  | 2017-02-01 |
| 2  | iPhone 5 | 6512    | 2017-02-02 |
| 3  | iPhone 4 | 165489  | 2017-02-03 |
| 4  | iPhone 4 | 135416  | 2017-02-05 |
| 5  | iPhone 6 | 65459   | 2017-02-19 |
+----+----------+---------+------------+

要得到如下结果:

+----+----------+---------+------------+
| id | phone    | points  | updated    |
+----+----------+---------+------------+
| 4  | iPhone 4 | 135416  | 2017-02-05 |
| 5  | iPhone 6 | 65459   | 2017-02-19 |
| 2  | iPhone 5 | 6512    | 2017-02-02 |
+----+----------+---------+------------+

Answer 1

试试这个

   SELECT
         p1.id,p1.phone,p1.points,p2.updated 
   FROM your_table p1
   JOIN (
        SELECT MAX(updated) as updated 
   FROM your_table GROUP BY phone)p2
   ON p2.updated = p1.updated 
   ORDER BY p1.points desc;