Hi, I have a table similiar to this: ColA Col B 100 Dog 101 Cat 101 Horse 102 ouse When there is a duplicate in ColA, I want to delete the entire row of one of the duplicates and just keep one. Sometimes there might be three or four of these, and I just want one. How can i do this? SQL Statement or something else? Thank you!