I have a SQL table with many fields. I need to find duplicates in them but using different scenarios. I would like to use a single query to check all dupe conditions at once. I am not sure how to do that. The query should check one by one condition and give me the number of dupes.
Please find the attached spreadsheet where I have laid out my sample data with dupe check conditions.
Hope my explanation is clear.
Your help is greatly appreciated.