怎样查找重复记录是偶数的记录

redrac

ID	SERIAL	DATED
1	A-C	2011
2	B-D	2011
3	F-C	2011
5	F-C	2011
76	A-C	2011
87	F-C	2011
9	A-C	2011
7	A-C	2011

如上表，
serial列里面有几个是重复的，我需要把重复次数是偶数的筛选出来，结果应该是

ID	SERIAL	DATED
1	A-C	2011
76	A-C	2011
9	A-C	2011
7	A-C	2011

应该怎么实现呢？

dsmch

=IF(MOD(COUNTIF($B$1:$B$8,B1),2)=0,1,"")

redrac

用SQL语句。。

zxb7679

一条语句实现的技巧太高，分步就简单些

redrac

zxb7679 发表于 2011-8-26 16:32
一条语句实现的技巧太高，分步就简单些

难道没有类似
group by sessionid
having count(sessionid)%2 =0
的用法么。。

zxb7679

SELECT Sheet1.SERIAL, Sheet1.DATED
FROM Sheet1
GROUP BY Sheet1.SERIAL, Sheet1.DATED
HAVING (((Count([Sheet1].[ID]) Mod 2)=0));

zxb7679

一条语句的
SELECT Sheet1.*
FROM Sheet1 INNER JOIN [SELECT Sheet1.SERIAL, Sheet1.DATED
FROM Sheet1
GROUP BY Sheet1.SERIAL, Sheet1.DATED
HAVING (((Count(Sheet1.ID) Mod 2)=0))]. as 查询1 ON (Sheet1.DATED = 查询1.DATED) AND (Sheet1.SERIAL = 查询1.SERIAL);

redrac

zxb7679 发表于 2011-8-26 17:01
一条语句的
SELECT Sheet1.*
FROM Sheet1 INNER JOIN [SELECT Sheet1.SERIAL, Sheet1.DATED

谢谢了～可用