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

转载于:https://blog.51cto.com/alun51cto/2114325