sql help

[cougartrace]

Just can think right now, If I have a table that looks like the following:

X Y
= =
A 1
B 2
C 1
D 2

What is the query I need to return all X rows where column Y has multiples of the same value?

 

[blom0344]

SELECT X,COUNT FROM TABLE
GROUP BY X
HAVING COUNT(Y) > 1

Ties Blom