请问如何删除这样一个表的重复记录

[winsock2000]

表ervery的数据：

kahao dateNow xfje
001 2005-01-02 1.75
001 2005-01-02 1.75 //删除
001 2005-01-03 1.75
002 2005-01-02 1.75
002 2005-01-02 1.75 //删除
。。。。。。。。。。。。。。。

请教一下如何把表里面重复数据给删除了。

[LBYYBL]

select distinct * into temp from ervery
truncate table ervery
insert into ervery select * from ervery
drop table temp

[mrjiangyan]

delete ervery from ervery a,(select xfje from ervery group by xfje having count(*)>1) b
where a.xfje=b.xfje

[JafyLiu]

delete ervery from ervery where xfje in
(select xfje from ervery group by xfje having count(xfje)>1)

[daiweihappy]

select distinct * into temp from ervery
truncate table ervery
insert into ervery select * from temp
drop table temp