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 阅读(241) 评论(0) 推荐(0)