Sergey,
no,
I simply use a kind of SELECT that first states the aggregate expressions first and then all other. Beeing lazy its easy (infact I use a prg) the get all the numbers, its much more work to wite all those names. Sorts are similar (and much less then group by).
Agnes
>I guess you like to count ...
>
>>I normaly use
>>
>>
>> GROUP BY 1, 2, 3 ,6 ;
>> ORDER BY 1, 2, 3 ;
>>
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]