Tracy.Bai

Focus on Data analysis and Mining

导航

2009年1月19日

一条语句删除表中某字段重复的数据

摘要: 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) 编辑