Find dublicates when SQL is your friend

Just to remember it another day. If you want to find which elements there is more then one time.


SELECT CODE
FROM table
GROUP BY CODE
HAVING count(CODE) > 1


It helped me a lot, so I hope you, my reader can utilise it as well.