Hey all, just trying to sneak in a couple posts before the month ends (can't have a month without posts; just feels wrong).
Alright this was a useful something that I used way back whenever and recently had to reuse:
SELECT Col1, COUNT(*) AS Total
FROM Table1
--WHERE SomeCondition
GROUP BY Col1
HAVING COUNT(*) > 1
ORDER BY COUNT(*) ASC
This query will list the number of times a value in Col1 is duplicated (i.e. if appears more than one time).
Handy for finding copies of a value that is only supposed to appear once in a table.
You can, of course, adjust the "HAVING" section to suit your needs (e.g. HAVING COUNT > 3, HAVING COUNT = 1, etc) thereby creating a more generalized search query.
DISCLAIMER: As stated, I’m not an expert so please, PLEASE feel free to
politely correct or comment as you see fit. Your feedback is always
welcomed. :-)
No comments:
Post a Comment