Chris <dmagick@xxxxxxxxx> writes: > Quick test: > create table a(a int primary key, b int, c varchar(200)); > insert into a(a, b, c) values (1,1,'one'); > insert into a(a, b, c) values (2,2,'two'); > insert into a(a, b, c) values (3,1,'one'); > insert into a(a, b, c) values (4,2,'two'); > mysql> select a,b,c from a group by b; > +---+------+------+ > | a | b | c | > +---+------+------+ > | 1 | 1 | one | > | 2 | 2 | two | > +---+------+------+ > 2 rows in set (0.00 sec) Egad :-(. At least the SQL spec has some notion of wanting the answer to a query to be well-defined ... regards, tom lane
