Archives of the TeradataForum

Message Posted: Tue, 20 Apr 2004 @ 21:45:09 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

In the past, I have aggregated a,b,c,d by using AVG, MAX, MIN, etc. It might be fine for your data, and it's kind of a quick fix. A slightly more complicated solution could be created using a derived table to do the group by of the aggregated values.

	<Prev	Next>		<<First	<Prev	Next>	Last>>