使用：
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_idAND y.m_il_no = x.m_il_no
使用：
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_idAND y.m_il_no = x.m_il_no
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
