8/6/12

Finding duplicates SQL


SELECT item_id,
 COUNT(item_id) AS NumOccurrences
FROM item
GROUP BY item_id
HAVING ( COUNT(item_id) > 1 )

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)