20 Feb
2016
20 Feb
'16
8:47 p.m.
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