In PostgreSQL you can do it like this:

SELECT path, mds.md5
FROM 
    ( SELECT md5, COUNT(*) AS cnt
      FROM files GROUP BY md5) AS mds
    LEFT JOIN files ON files.md5=mds.md5
WHERE mds.cnt > 1
[download]