Chris <dmagick(at)gmail(dot)com> 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