slightly different duplicate query 1

[cdipaolo]

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

 

[traingamer]

try (not tested):

Select product, location, Count(product) as Dups
from PRICES
Group By product, location
where Count(product) > 1;

should return the combinations that occur more than once.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[cdipaolo]

Thanks - you just need to change the "where" to "having" since count is an aggregate function. Exactly what I was looking for.