MySQL Query

[ozzie]

HELP! I'm Trying to find duplicate CompanyNames by doing the following in MySQL which obviously doesn't work because it isn't supported. Please can someone suggest a way of doing this which is supported?

SELECT CompanyCode
  FROM company_old
    WHERE CompanyName IN (
      SELECT CompanyName, Count(*) 
        AS count 
        FROM company_old
        GROUP BY CompanyName
        HAVING count(*) > 1
    )

Thanks!

[[deleted]]

Try this:

SELECT COUNT(1) AS occurences, name
FROM table
GROUP BY name
HAVING occurences > 1;