<div>
<div class="content wysiwyg-content">
If I have a query like: &nbsp;<br />
select MyText, cnt=(count(*) FROM TableB where TableAId=a.TableAId) FROM TableA a<br />
and I would only like to select those rows where cnt&gt;5. How do I do that?<br />
<br />
<br />

</div>
</div>


If I have a query like:  
select MyText, cnt=(count(*) FROM TableB where TableAId=a.TableAId) FROM TableA a
and I would only like to select those rows where cnt>5. How do I do that?




subquery  cnt&gt;x

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.

subquery cnt&gt;x

subquery cnt>x