Re: group by / columns

> The simple answer is NO.
>
> The order by can use the position of the column ( 1, 2,3,...). In fact
> when writing a union, the order by clause must use positions.
>
> Group by must be complete column information without the alias.
>
> Most editors allow cut and paste. Write out the select, then build the
> group by clause.

Yes, I know, but i've become lazy over the years and writing group by 1,2,3 is much easier. I think it is easier to read as well. Ah well, I'll learn to live with it :)

Sammy Received on Tue Feb 06 2001 - 05:30:32 CST