SQL语句就可以做了,例检索表格aaa,添加一列“re_num”,显示a列值重复的次数,
次数为表格按a列分组计算记录数:
select a,count(a) as 're_num' from aaa group by a,
select a1.*,a2.re_num from aaa a1 join (select a,count(a) as 're_num' from aaa group by a) a2 on a1.a = a2.a;