On gists

Sql - nalezeni duplicitnich radku (více sloupců)

MySql

sql-duplicity-rows.sql Raw #

SELECT DISTINCT t1.id
FROM tabulka t1
JOIN tabulka t2 ON t2.sloupec1 = t1.sloupec1
AND t2.sloupec2 = t1.sloupec2
AND t2.id < t1.id