SQL GROUP BY

Creator
Creator
Seonglae ChoSeonglae Cho
Created
Created
2020 Feb 18 5:24
Editor
Edited
Edited
2022 May 11 14:4
Refs
Refs
HAVING
  • 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 에서 그냥 지우기
 

Recommendations