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 paulroberthill@gmail.com wrote:
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