Mysql Duplicate rows - same table - not primary col
Look for duplicate rows, in the same table, by a different column (not primary or unique).
Copy this code and paste it in your HTML
SELECT p1.id
,p1.cod
, p2.id
,p2.cod
#here we find the duplicate data from cod column, but i need the ID to show ... FROM `st_produse` p1
#the table, first time LEFT JOIN st_produse p2
ON p1.cod
= p2.cod
#the table second time WHERE p1.id
<> p2.id
#here put the key or a unique column GROUP BY p1.cod
#the column in case, first time
Report this snippet
Comments
Subscribe to comments