Delete all duplicates where two columns are the same

Hi guys

I have 33,000 rows however some are duplicates.

I need to remove all the rows where Columns Start and Teacher are the same.

I know how to remove rows where 1 column is the same. But how can I do it when I need to do it on 2 columns

Regards

Chris

How do you do it with 1 column?

using Group BY

do the same for 2 columns :slight_smile:

p.s. are you sure you want ~all~ duplicates to be removed?

usually people want to retain one of them…