remove duplicates based on one (or a few) columns

[Koert Kuipers]

what is the easiest way to remove rows which are considered duplicates based
upon a few columns in the rows?
so "create table deduped as select distinct * from table" won't do...