SQL question
From: miguel <jmiguel_at_cet.pt>
Date: 1998/01/13
Message-ID: <01bd2030$3d6218c0$0a0a2c0a_at_jmiguel.cet.pt>#1/1
Date: 1998/01/13
Message-ID: <01bd2030$3d6218c0$0a0a2c0a_at_jmiguel.cet.pt>#1/1
Hi,
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 Tue Jan 13 1998 - 00:00:00 CET