Sunday, 30 September 2007

TSQL: Get Duplicate Rows Count

--Get Duplicate Row Counts
SELECT hrerequestforapprovalid, count(*)
FROM hrerequestforapproval
GROUP BY hrerequestforapprovalid
HAVING count(*) > 1
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)