sql 去除重复数据（多字段）

Question

我现在有个表 表里面有ID No,Pass

然后根据No,Pass相同的数据，保留Max(ID)数据,删除其他，如何做？

我是这么做的，不知道行不行

delete Min(ID),CAST(No AS VARCHAR)+CAST(Pass AS VARCHAR)

from Table group by
No, Pass having count(*) > 1

Answer 1

试一下

DELETE 
FROM Table
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM Table
GROUP BY No
    , Pass
)