DISTINCT COUNT (*) will return a row for each unique count. What you want is COUNT(DISTINCT <expression>) : evaluates expression for each row in ... ... <看更多>

This is how I'd do it: SELECT * FROM #MyTable AS mt CROSS APPLY ( SELECT COUNT(DISTINCT mt2.Col_B) AS dc FROM #MyTable AS mt2 WHERE mt2. ... <看更多>

... <看更多>