摘要: --可以检测到null列重复delete from [JCXS0201] where USER_ID in(select User_ID u from [JCXS0201] group by User_ID having COUNT(id) >1 ) and id not in (select MIN(id) from [JCXS0201] where USER_ID in( select User_ID from [JCXS0201] group by User_ID having COUNT(id) >1 ) )--不可以检测到null列重复delete from [JC... 阅读全文
posted @ 2012-09-27 15:11 二师弟tl 阅读(916) 评论(10) 推荐(0) 编辑