一条语句删除重复行

一条语句删除重复行

--可以检测到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 ) )

www.2cto.com

--不可以检测到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] group by User_ID having COUNT(id) >1 )