Diffrence between groupby and orderby clause

[parveen]

Hi,

I have two questions:-

(1)Diffrence between groupby and orderby clause
(2)what are environment variables means $_ENV

plz help me.


Thanks & Regards

Parveen

[Bigcats82]

Group by lists what fields you want to be grouped together. This is used more for break logic and summing fields.

Order by tells you what fields you want to be sorted. This can be ascending or descending.