例如表test:
ID | NAME | AGE |
1 | a | 10 |
2 | a | 10 |
3 | b | 10 |
筛选出name和age不重复的数据
SELECT a.id, a.name, a.age
FROM (SELECT t.id, t.name, t.age, CONCAT(t.name, t.age) AS is_repeat FROM test t GROUP BY t.isrepeat) a
结果:
ID | NAME | AGE |
3 | b | 10 |
例如表test:
ID | NAME | AGE |
1 | a | 10 |
2 | a | 10 |
3 | b | 10 |
筛选出name和age不重复的数据
SELECT a.id, a.name, a.age
FROM (SELECT t.id, t.name, t.age, CONCAT(t.name, t.age) AS is_repeat FROM test t GROUP BY t.isrepeat) a
结果:
ID | NAME | AGE |
3 | b | 10 |