移除uesr
表中重复的name
、age
行
mysql> select * from user;
+----+--------+-----+
| id | name | age |
+----+--------+-----+
| 1 | 张三 | 11 |
| 2 | 张三 | 11 |
| 3 | 李四 | 11 |
+----+--------+-----+
3 rows in set (0.00 sec)
mysql> delete from user
-> where id not in
-> (select * from
-> (select min(id) from user group by name,age)as a);