sql查询，更新自己表的数据

WITH A AS(SELECT TeaID,COUNT(*) C FROM #tmp) UPDATE #tmp SET rowC=C FROM #tmp JOIN A ON #tmp.TeaID=A.TeaID