In article <[EMAIL PROTECTED]>, Justin Swanhart <[EMAIL PROTECTED]> writes:
>> Where is the implicit group? The 'order by' >> shouldn't effect how things >> are grouped. On MySQL 4.0.17: > Wow. I wasn't aware. Is that expected behavior? > Other databases (Oracle) generate an error when you > include columns in the select list that aren't in a > group by, Yes, because the SQL standard prohibits this. > ... or they do an implicit group by (postgres) > on the columns. Huh? PostgreSQL throws an error - as it should do. > I [wrongly] assumed an implicit group > by was going on because the query hadn't generated an > error. Nope; that's a MySQL "extension to the SQL standard" which confused everyone and has few real use cases: MySQL groups by email and then fetches a random first and last name out of the group. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]