SQL Server中打印统计某字段有相同数据的行数
此方法扩展空间很大,例如可以作子查询用于统计,“干净”纪录导出等等
SELECT [COL_NAME], COUNT([COL_NAME]) AS Expr1
FROM [TABLE_NAME]
GROUP BY [COL_NAME]
HAVING (COUNT([COL_NAME]) > 1)
FROM [TABLE_NAME]
GROUP BY [COL_NAME]
HAVING (COUNT([COL_NAME]) > 1)