56,679
社区成员
发帖
与我相关
我的任务
分享
mysql> select distinct id1,id2,cont from t3;
+------+------+--------+
| id1 | id2 | cont |
+------+------+--------+
| 2 | 4 | 北京 |
| 3 | 1 | 西安
|
| 3 | 4 | 郑州 |
| 5 | 1 | 西藏 |
+------+------+--------+
4 rows in set (0.00 sec)
mysql> select distinct id1,id2,cont from t3 group by id1,id2;
+------+------+--------+
| id1 | id2 | cont |
+------+------+--------+
| 2 | 4 | 北京 |
| 3 | 1 | 西安
|
| 3 | 4 | 郑州 |
| 5 | 1 | 西藏 |
+------+------+--------+
4 rows in set (0.00 sec)
select id1,id2,cont from a group by id1,id2