SELECT     [COL_NAME], COUNT([COL_NAME]) AS Expr1
FROM         [TABLE_NAME]
GROUP BY [COL_NAME]
HAVING      (COUNT([COL_NAME]) > 1)