Re: Problem with GROUP BY

Author: Paul Hill

Posted: 2016-02-20 at 14:47:15

On 20 February 2016 at 20:34, Jean MAURICE <jsm.maurice@wanadoo.fr> wrote:

> Le 20/02/2016 21:28, mbsoftwaresolutions@mbsoftwaresolutions.com 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: ProFox@leafe.com

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_tg@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.

©2016 Paul Hill