>>Interesting group of threads Sergey. I looked at several and found that I would have recommended an ORDER BY before the GROUP BY in order to specify which records are shown in the results. I've never had any problem as long as I used ORDER BY - have I been missing something?
>>
>
>Since ORDER BY isn't applied until you reach the final results, it doesn't affect grouping.
>
>Tamar

Not true! If you ORDER BY DATE, GROUP BY DATE you'll get one record for each date - but if you ORDER BY CUSTOMER, GROUP BY DATE you'll get completely different results!