One occurrence of a word only - Delete repeated rows

[damipera]

hi guys any advice how to do this please? i want to delete the rows that are repeated. i just want 1 occurrence of a word. thanks for any help.

from table like this:

words
------
apple
apple
grapes
banana
grapes
blueberry
grapes
blueberry
apple
plum
plum
blueberry
banana
blueberry

into this:

words
--------
apple
grapes
banana
blueberry
plum

 

[mossbs]

something like

select distinct('words') from 'TABLE_NAME'

would select what you are after from that table, (obviously change 'words' to the column name, and 'TABLE_NAME' to the actual table name)

not sure if that is what you are after though?!

 

[damipera]

hi mossbs, actually what i want is to delete the rows that are repeated and not really to have a recordset of unique/distinct rows.