I need to try and select all similar pairs that occur in the table more than once. For example, in the above table, I would be looking to select Soup and Beef and Salad and Pork as they occur more than twice.
posted 8 years ago
Off the top of my head, something like: SELECT Starter, Main, Count(Main)AS cnt FROM my_table WHERE cnt>1; should get you a list of any duplicates. [ August 29, 2007: Message edited by: Chad Clites ]