删除重复数据

[朕赐你肥皂]

我现在有个表 表里面有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

[朕赐你肥皂]

2条数据貌似可以，超过2条就不行~

[朕赐你肥皂]

select ID from Table WHERE ID not in( select Max(ID) from Table group by No, Pass having count(*) > 1) and CAST(No AS VARCHAR)+CAST(Pass AS VARCHAR) in (select CAST(No AS VARCHAR)+CAST(Pass AS VARCHAR) from Table group by No, Pass having count(*) > 1) 这样貌似是可以的，期待高手解决！

[还在加载中灬]

如果ID不会重复，可以用以下方式

DELETE TB
WHERE ID NOT IN(SELECT MAX(ID)FROM TB GROUP BY NO,PASS)

[还在加载中灬]

如果会重复，可以这样

DELETE T1
FROM TB T1
	JOIN(SELECT MAX(ID)ID,NO,PASS FROM TB GROUP BY NO,PASS)T2
		ON T1.NO=T2.NO AND T1.PASS=T2.PASS AND T1.ID<>T2.ID
SELECT * FROM TB

[朕赐你肥皂]

晕。。。。。。。。。。。。崩溃了。。。。 DELETE TB WHERE ID NOT IN(SELECT MAX(ID)FROM TB GROUP BY NO,PASS) 这个貌似阔以。。。不管了，先给你结贴！