用分组,组内计数就可以了,意思就是根据字段a的取值进行分组,相同的为一组,在用count进行组内计数。select a,count(*) from a group by a 扩展资料:sql统计重复数据 1、生成表 create table test1 col1 char(2), col2 int go 2、插入数据 insert into test1 values('aa',1000);inse...
private sub geshu(xx as integer)dim i as integerdim conn as adodb.connectiondim workstring as stringdim sqlcommand as stringdim rs as adodb.recordsetset conn = new adodb.connectionworkstring = "p...