I want to delete all the records in a table that have the same manifest number but keep the one record of it in the table. How would I do this?

Tyler