遇到的问题:
只想查到在数据表里出现一次的数据,出现多次的直接跳过,而不是去重。
例子:

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
查出来的结果是:

1558