Selecting/Deleting duplicates in a table?

[Guest_imported]

Hi all,
I am trying to delete duplicate records. I know how to select dups using this code:
select * from temptbl A where exists;
(select * from temptbl B where B.dupfield = A.dupfield;
group by dupfield having count(*) > 1 )

I have tried changing this code to delete the records but I cannot get the syntax down.
Can anybody point me in the right direction?

thanks,
scotta

 

[JimEkleberry]

Check out this article:

http://www.sqlteam.com/item.asp?ItemID=3331