Solving error message 'An aggregate may not appear in the WHERE clause'
Posted on 2014-03-17
As title says im getting that error message, I know why im getting it but what is the best work around? Ive tried a few but must be getting the syntax wrong.
SELECT PartNumber, Manufacture, COUNT(PartNumber) as TheCount
WHERE COUNT(PartNumber) > 1
Group BY PartNumber, Manufacture