- delete duplicated rows
SELECT a.* FROM blur_residue AS a LEFT JOIN blur_residue AS b ON a.pvrid = b.pvrid GROUP BY a.pvrid HAVING COUNT(a.pvrid) = 4
하고 heidi 에서 그냥 지우기
Seonglae Cho
Seonglae ChoSELECT a.* FROM blur_residue AS a LEFT JOIN blur_residue AS b ON a.pvrid = b.pvrid GROUP BY a.pvrid HAVING COUNT(a.pvrid) = 4