truncate won't work if you are only trying to delete some of the records... it will empty the table completely.