由“一条语句删除重复行”引发的数据库 NULL行的问题
由“一条语句删除重复行”引发的数据库 NULL行的问题<div class="postbody"><div id="cnblogs_post_body"><div class="cnblogs_code">--可以检测到null列重复
delete from [JCXS0201] whereUSER_ID in(select User_ID u from [JCXS0201] group by User_IDhaving COUNT(id) >1 ) andid not in (select MIN(id) from [JCXS0201] where USER_ID in( select User_ID from[JCXS0201] group by User_IDhaving COUNT(id) >1 ) )
页:
[1]