how about

1. create new table as select * from exiting table
where records are the one you wnat to keep.
2. drop existing table.
3. rename new table to existing table.