一条语句删除表中某字段重复的数据
摘要: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
Focus on Data analysis and Mining
posted @ 2009-01-19 15:10
posted @ 2009-01-15 09:39
posted @ 2009-01-09 15:41