My experience with VFP is that the order of the fields in the GROUP BY clause allows me to skip the ORDER BY clause. The grouping is always the same, no matter the order.
On February 20, 2016 3:47:15 PM EST, Paul Hill <[email protected]> wrote: >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 -- Sent from my Android device with K-9 Mail. Please excuse my brevity. _______________________________________________ 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/[email protected] ** 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.
