获取相同记录中公共字段的计数，SQL Server?

Question

假设我们有以下记录:

<表类> Id 列一个 列B 列C 常见 tbody><<tr>1Value1Value2Value3122Value1Value2Value3133Value1Value2Value308年4Value1Value2Value3105Value4Value5Value6186Value4Value5Value6227Value4Value5Value637

简写

SELECT MIN(ID), ColumnA, ColumnB, ColumnC, COUNT(*)
FROM la.JudicialReference
GROUP BY ColumnA, ColumnB, ColumnC

可与HAVING COUNT(*) > 1一起使用