Hello Michael, Tuesday, September 30, 2008, 8:00:36 PM, you wrote: Andrew>> However if the specific sorting algorithm is not stable it *might* MW> It's not stable; MySQL is using several different technics to MW> calculate GROUP BY and may thus return the rows in any order within MW> the group by.
Thanks for clarification. MW> In general with SQL: Don't assume any order of rows if you don't MW> explicitely specify a sort order. Sure. But sometimes, knowing how the system works internally, we can still make a kludge. -- Best regards, Andrew mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]