2007年
-
编辑 删除
sql server 删除重复记录
DELETE TMP FROM (SELECT ID,MIN(STATE) STATE FROM TMP GROUP BY ID HAVING COUNT(1)>1) B WHERE TMP.ID=B.ID AND TMP.STATE<>B.STATE[@more@]
