manifesto42.com
Find duplicate records in SQL table
There are a few ways to do this, but i am leaving this one here so its easy to find. SELECT nome, COUNT(nome) FROM Patrimonio GROUP BY nome HAVING ( COUNT(nome) > 1 ) This returns a list with tw…