<div>
I'm not sure if it is deliberate or not but you have omitted GROUP BY in your question; but you refer to getting record<b>S</b> (plural) so I assume a group by being used.<br />
<br />
SELECT o.MyTableId, COUNT(*) &nbsp;as cnt<br />
FROM OtherTable o <br />
GROUP BY o.MyTableId<br />
HAVING COUNT(*) &nbsp;&gt; 0<br />
<br />
Use a HAVING clause which allows you to filter the aggregated values, here it will remove all counts of zero from the result.
</div>


I'm not sure if it is deliberate or not but you have omitted GROUP BY in your question; but you refer to getting recordS (plural) so I assume a group by being used.

SELECT o.MyTableId, COUNT(*)  as cnt
FROM OtherTable o
GROUP BY o.MyTableId
HAVING COUNT(*)  > 0

Use a HAVING clause which allows you to filter the aggregated values, here it will remove all counts of zero from the result.

<div>
<div class="content wysiwyg-content">
Hello,<br />
How do I only to get records that have Cnt&gt;0 in <br />
<br />
SELECT MyTableId, Cnt=(SELECT COUNT(*) FROM OtherTable o where o.MyTableId=m.MyTableId)<br />
&nbsp;FROM MyTable m
</div>
</div>


Hello,
How do I only to get records that have Cnt>0 in 

SELECT MyTableId, Cnt=(SELECT COUNT(*) FROM OtherTable o where o.MyTableId=m.MyTableId)
 FROM MyTable m

aggregate only get when &gt;0

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.

aggregate only get when &gt;0

aggregate only get when >0