sql语句查询重复的字符串

select id, name, memo
from A
where id in (select id from A group by id having count(1) >= 2)

 

 

有点点复杂，不如用excel来的快

=COUNTIF(A:A,A1)