>>>>Delete myTable from myTable inner join Dups on myTable.DupKey = Dups.DupKey and myTable.PK > Dups.MinKey
>>
>>can you tell me about the last part? How does the primary key being greater than the minkey granted the minkey stands for minimum key going to help us?
>
>The idea is to remove all duplicates except one. I chose the one with the Min primary key to stay in the table.

urrrg well i have no Primary key but im thinking. is there a way like i could do a count?
like count(mytable.fname) as names having for example having names>1 ann do "x" untill having =1?