{"id":292,"title":"sql\u591a\u8868\u5220\u9664","good":0,"bad":0,"hit":2334,"created_at":"2018-06-14 22:19:00","content":"<p>\u591a\u8868\u5220\u9664\uff1a<\/p><p>\u5220\u9664\u672c\u8868\u4e2d\u91cd\u590d\u7684\u6570\u636e\uff0c\u4fdd\u7559\u91cd\u590d\u6570\u636e\u4e2did\u8f83\u5c0f\u7684<\/p><p>delete from goods as t1 left join (select id,name from good group by name having count(name)&gt;=2) as t2 on t1.name=t2.name where t1.id&gt;t2.id;<\/p><p><br\/><\/p>"}