Grimoire-Command.es

GNU+Linux command memo

List dups in SQL table

Lister les doublons dans une table SQL

SELECT $field FROM $table WHERE $field IN (SELECT $field FROM $table GROUP BY $field HAVING COUNT(*) > 1)