SELECT Liste.Firma FROM Liste INNER JOIN (SELECT Firma FROM Liste GROUP BY Firma HAVING count(id) > 1) dup ON Liste.Firma = dup.Firma
SELECT Liste.Firma FROM Liste INNER JOIN (SELECT Firma FROM Liste GROUP BY Firma HAVING count(id) > 1) dup ON Liste.Firma = dup.Firma