delete multiple rows

[mici]

i would like to write a statement who finds all the multiple rows in a field.
(the opposite of distinct)
I need to delete all the extra rows, that the data will show only once
ex: (the extra dog and caw will be deleted)

cat cat
dog dog
dog frog
frog caw
caw
caw

 

[donutman]

Do you have a primary key to work with? Tell us some more about your table structure.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]