does the order matter in group by clause.

[#1]

Hi Everone

couple of question on order by query in qlikview. does it exactly behave the same way it does in SQL,

If i am doing group by on multiple columns for example.

Load a,b,c, sum(d) from .... group by a,c,b

does the order of group by which fields comes first or second matters?

can you please explain this in detail with example.

[anbu1984]

Order in group by clause doesn't affect your query result

Result of both the below queries are same

- Load a,b,c, sum(d) from .... group by a,c,b

- Load a,b,c, sum(d) from .... group by a,b,c