SQL中查找某字段值重复或多个字段值重复的记录数

只筛选一个字段值相同的记录

select * from A where PDDT in(
	select PDDT FROM A 
	group by PDDT
	having count(PDDT)>1
)

筛选多个字段值相同的的记录

SELECT COUNT(*),DeptID, PDDT , DLNo , DLNoRe, MacNo
	FROM A
	GROUP BY DeptID, PDDT , DLNo , DLNoRe, MacNo
	having count(*)>1