SQL Question

From: miguel <jmiguel_at_cet.pt>
Date: 1998/01/15
Message-ID: <01bd2197$c1043a60$0a0a2c0a_at_jmiguel.cet.pt>#1/1


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 CET

Original text of this message