CODE: find duplicate urls

SELECT     MAX(id) AS ids, COUNT(*) AS num
FROM         dbo.tbl_contacts
GROUP BY url
HAVING      (COUNT(*) > 1)

Software engineers do the job better!