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)
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)