删除一个表中的相同的数据


delete from tb_followinfo a where a.id <> (select max(id) from tb_followinfo b where b.followuid = a.followuid AND b.uid = a.uid)

posted @ 2012-11-26 14:22  简单--生活  阅读(203)  评论(0编辑  收藏  举报
简单--生活(CSDN)