<div>
<pre><code id="code-20-39933801-1">SELECT     PartNumber, Manufacture, COUNT(PartNumber) as TheCount
FROM         CounterfeitParts
HAVING COUNT(PartNumber) &gt; 1
Group BY PartNumber, Manufacture</code></pre>
</div>


SELECT     PartNumber, Manufacture, COUNT(PartNumber) as TheCount
FROM         CounterfeitParts
HAVING COUNT(PartNumber) > 1
Group BY PartNumber, Manufacture

<div>
Incorrect syntax near the keyword 'Group'.
</div>


Incorrect syntax near the keyword 'Group'.

<div>
however, doing a count(PartNumber) here is usually better COUNT(*) instead ...
</div>


however, doing a count(PartNumber) here is usually better COUNT(*) instead ...

<div>
I know Guy (aka Scary Scar Puffy Shirt Dude) has already correctly answered your question, but if it helps I have an article out there on <a href="https://www.experts-exchange.com/Database/MS-SQL-Server/A_12312-SQL-Server-GROUP-BY-Solutions.html" rel="ugc">SQL Server Group By Solutions</a>, and point #3 illustrates the HAVING clause. &nbsp; If the article helps you, please click the 'Yes' button at the bottom.
</div>


I know Guy (aka Scary Scar Puffy Shirt Dude) has already correctly answered your question, but if it helps I have an article out there on SQL Server Group By Solutions [https://www.experts-exchange.com/Database/MS-SQL-Server/A_12312-SQL-Server-GROUP-BY-Solutions.html], and point #3 illustrates the HAVING clause.   If the article helps you, please click the 'Yes' button at the bottom.

<div>
<div class="content wysiwyg-content">
Hi guys,<br />
<br />
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.<br />
<br />
SELECT &nbsp; &nbsp; PartNumber, Manufacture, COUNT(PartNumber) as TheCount<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; CounterfeitParts<br />
WHERE &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COUNT(PartNumber) &gt;&nbsp;1<br />
Group BY PartNumber, Manufacture<br />
<br />
Thanks,<br />
Dean
</div>
</div>


Hi guys,

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
FROM         CounterfeitParts
WHERE	COUNT(PartNumber) > 1
Group BY PartNumber, Manufacture

Thanks,
Dean

Solving error message 'An aggregate may not appear in the WHERE clause'

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.