一条语句删除表中某字段重复的数据
DELETE FROM dbo.article WHERE ID NOT IN (SELECT minid FROM (SELECT title,MIN(ID) AS minid FROM dbo.article GROUP BY title) a)
posted on 2009-01-19 15:10 Love Fendi 阅读(238) 评论(0) 编辑 收藏 举报
Focus on Data analysis and Mining
posted on 2009-01-19 15:10 Love Fendi 阅读(238) 评论(0) 编辑 收藏 举报