龙 龙之天涯 Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-31 #1 假如有100条记录，里面有重复的记录，用什么sql语句知道重复记录的个数。
J jsxjd Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-31 #3 select count(*) from (select distinct id from table) select count(*) from table
L LiGen Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-31 #4 while not Table.eof do Begin if True then count:=Cont + 1 ; Next; end;
S smallbs Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-31 #5 select count(*) from table where id in (select a.id from (select id,count(*) as kkk from table group by id) a where a.kkk>1)
select count(*) from table where id in (select a.id from (select id,count(*) as kkk from table group by id) a where a.kkk>1)
碧 碧血剑 Unregistered / Unconfirmed GUEST, unregistred user! 2003-01-01 #6 select id, count(*) from table group by id having count(*) >1
