我能查到有这样的现象存在,但我不能提取具体是哪两条记录? 请问有什么办法吗? SELECT * FROM (SELECT COUNT(*) AS Expr1 FROM (SELECT * FROM cdr WHERE (AreaCode = '8621') AND (StartDate >= '2005/12/01') AND (StartDate <= '2005/12/31')) DERIVEDTBL GROUP BY RegistrarNo, CalleeID, StartDate, StartTime) DERIVEDTBL WHERE (Expr1 = 2)
先行谢过,可我的意思是 我该怎么构造这个查询---
来
找到B表里 对应我的左链接的条件的字段相同的重复记录吗?
换句话说: 我怎么能找出B表里某些字段相同的记录? 用COUNT + GROUPBY吗?
SELECT *
FROM (SELECT COUNT(*) AS Expr1
FROM (SELECT *
FROM cdr
WHERE (AreaCode = '8621') AND (StartDate >= '2005/12/01') AND
(StartDate <= '2005/12/31')) DERIVEDTBL
GROUP BY RegistrarNo, CalleeID, StartDate, StartTime) DERIVEDTBL
WHERE (Expr1 = 2)