MySQL查询去重

DISTINCT

• distinct name 是去除name字段的重复值,返回name字段列

select distinct name from user;

+-------+
| name  |
+-------+
| zs    |
| admin |
| loso  |
+-------+

• distinct name,home 是去除name和home共同重复的值并且返回

select distinct name,home from user;

+-------+-------+
| name  | home  |
+-------+-------+
| zs    | China |
| admin | China |
| loso  | China |
| zs    | xx    |
+-------+-------+

GROUP BY

select * from user group by name;
+----+-------+------+---------------------+--------+-------+----------+
| id | name  | age  | birthday            | gender | home  | isdelete |
+----+-------+------+---------------------+--------+-------+----------+
|  0 | admin |    0 | 2000-01-01 00:00:00 |        | China | 
        |
|  2 | loso  |   10 | 2000-01-01 00:00:00 |        | China |          |
|  1 | zs    |   10 | 2000-01-01 00:00:00 | 
      | China | 
        |
+----+-------+------+---------------------+--------+-------+----------+

LIMIT 1 (ORDER BY 时间字段 desc LIMIT 1)

SELECT * from org_phone_num WHERE `remove`=0 and phone = '073188872151' ORDER BY last_modified desc LIMIT 1;