I have a table (PRICES) with the following data:
product, location, price, date. I want to find all of the records where the product and location are the same (shouldn't have more than one combination of product/location). I'm having trouble finding the right combination of count() and group() functions to whittle the list down. Does anyone have a similar query that they would share?
Thanks,
Chris
product, location, price, date. I want to find all of the records where the product and location are the same (shouldn't have more than one combination of product/location). I'm having trouble finding the right combination of count() and group() functions to whittle the list down. Does anyone have a similar query that they would share?
Thanks,
Chris