简单的问题，关于删除重复记录

[客家族_Shark曾_小凡仙]

1 根据成员编码和日期 删除重复的数据，并留下其中最大ID的一条。

ID，成员编码，日期，工资，....。

[davorsuker39]

select ID，成员编码，日期，工资 fron table a where (select max(id) from table where 成员编码=a.成员编码,日期=a.日期 )

[davorsuker39]

select ID，成员编码，日期，工资 fron table a where id=(select max(id) from table where 成员编码=a.成员编码,日期=a.日期 )

[jiajian008]

delete table where (id in (select id from table where 成员编码=a.成员编码,日期=a.日期))
and (id <>(select max(id) from table where 成员编码=a.成员编码,日期=a.日期 )
)

[yanghongjy]

delete table where id = (select max(id) from table)

[客家族_Shark曾_小凡仙]

delete test
from test a
where ID<>
(
select max(id)
from test
where name=a.name and Money =a.Money
)

[yingqing]

select ID，成员编码，日期，工资 fron table a where id=(select max(id) from table where 成员编码=a.成员编码,日期=a.日期 )

[good2speed]

DECLARE @t TABLE(
id_num INT IDENTITY(1,1) UNIQUE CLUSTERED,
i INT
)

INSERT INTO @t(i)
SELECT 1 UNION ALL
SELECT 1 UNION ALL
SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT 2 UNION ALL
SELECT 3

DELETE @t
FROM @t AS t,(SELECT MIN(id_num) AS id_num,i FROM @t GROUP BY i) AS a
WHERE t.id_num <> a.id_num AND t.i = a.i

/**//* DELETE FROM @t WHERE id_num NOT IN (SELECT MIN(id_num) FROM @t GROUP BY i) */

SELECT * FROM @t

[ben1000]

若成员编号作为条件，则有：
delete table where 成员编号=已知 and ID<>(select max(ID) from table where 成员编号=已知)

[ben1000]

其实，这个很简单，不过楼主要写明条件，会更好些，这样我们也会更好的理解的。