Find doubles in SQL

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