On 20 February 2016 at 20:34, Jean MAURICE <[email protected]> wrote: > Le 20/02/2016 21:28, [email protected] a écrit : >> >> I've often thought: the order of your GROUPING doesn't matter....does it? >> Either way, it's the same distinct combination. > > No if you have'nt an order by clause : by default the order is the one given > by the group by (I hope it's understandable !)
Are you sure? I think the order would be undefined. Perhaps this is true for Fox but I am sure it is not true for other SQL variants. -- Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CADwx0+LKW+V0s1RqF5-Fcr-_L3Fk2Ft=ep7JZbzrwMse=wv...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
