SQL Question

Hi,
Can someone help me

Table TEST (A,B)

A B
1 10
1 11
1 12
2 10
2 11
2 13
3 10
3 11
3 12
4 8
4 11
4 14
How can i obtain the records that have the same value B group by A. For example i want a query to return:
A B
1 10
1 11
1 12
3 10
3 11
3 12

Thanks
Miguel Received on Thu Jan 15 1998 - 00:00:00 CST