Filtering out column values that don't repeat

A

anthonyd

Is there a way to filter out all the values in a column that only appear
once, leaving just items that appear 2+ times? I know there's a way to get
rid of duplicates, but I haven't been able to find a feature that would do
the opposite. Thank you for your insight!
 
O

Ofer Cohen

Using SubQueries try something like

SELECT T1.*
FROM TableName As T1
WHERE T1.FieldName In (SELECT T2.FieldName
FROM TableName As T2
GROUP BY T2.FieldName
HAVING Count(T2.FieldName)>=2)
 
Top