数据库删除重复列

DELETE FROM Comment WHERE CommentID NOT IN (
SELECT MAX(CommentID) FROM Comment  GROUP BY CommentContent, CommentDateTime
)

CommentContent, CommentDateTime 为重复的列

posted @ 2012-10-30 15:51  日月当空  阅读(190)  评论(0)  编辑  收藏  举报