一条语句删除表中某字段重复的数据
摘要:
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 @ 2009-01-19 15:10 Love Fendi 阅读(238) 评论(0) 推荐(0) 编辑
Focus on Data analysis and Mining
posted @ 2009-01-19 15:10 Love Fendi 阅读(238) 评论(0) 推荐(0) 编辑