First - these are not duplicates. Duplicates would be the same exact same values in each column. Second - you cannot identify these as duplicate unless you know what constitutes a duplicate row.
In your example, you have determined that price or location being different but everything else being the same would be considered a duplicate. Unless you already know this before you run a query there is no way you can determine that these are actual duplicates.
Expand on your example:
Product1, Price1, Location1,Region1
Product1, Price2, Location2,Region2
Product1, Price3, Location3,Region3
Product2, Price1, Location1,Region1
Product2, Price2, Location2,Region2
Product2, Price3, Location3,Region3
Are these duplicates because they have different values for price, location and region? Or is the combination of all 4 columns unique - defined the price for a specific location and region?