遇到的问题:
只想查到在数据表里出现一次的数据,出现多次的直接跳过,而不是去重。
例子:
SELECT name,count('name') AS count_times
FROM tb_test
GROUP BY name
HAVING count_times = 1
查出来的结果是:
只想查到在数据表里出现一次的数据,出现多次的直接跳过,而不是去重。
SELECT name,count('name') AS count_times
FROM tb_test
GROUP BY name
HAVING count_times = 1
查出来的结果是: