On 2/22/07, Martijn van Oosterhout <kleptog@svana.org> wrote:
On Thu, Feb 22, 2007 at 12:05:20PM +1100, Chris wrote: > >SELECT foo, bar, COUNT(*) > >FROM baz > >GROUP BY foo > That one actually comes in handy ;) Especially in older versions (4.0) > that don't support subselects.. I must say I don't see any reasonable way of interpreting the above query. Is the value of bar selected randomly?
The value of bar happens to be the first value fetched based on the GROUP BY of foo, not sure how predictable and repeatable it is.
