Posts by Eduardo de Sousa • 1 point
1 post
-
-3
votes2
answers32556
viewsA: How to remove duplicate lines efficiently?
DELETE a FROM tbl_xf AS a,tbl_xf AS b WHERE a.fk_x=b.fk_x AND a.pk_x < b.pk_x AND a.fk_x=8 AND b.fk_x=8
1 post
-3
votes2
answers32556
viewsDELETE a FROM tbl_xf AS a,tbl_xf AS b WHERE a.fk_x=b.fk_x AND a.pk_x < b.pk_x AND a.fk_x=8 AND b.fk_x=8