使用:
SELECT x.*,
y.num
FROM @t x
JOIN (SELECT t.collateral_id,
t.m_il_no,
COUNT(*) AS num
FROM @t t
GROUP BY t.collateral_id, t.m_il_no) y ON y.collateral_id = x.collateral_id
AND y.m_il_no = x.m_il_no