Archives of the TeradataForum

Message Posted: Sun, 05 Dec 2004 @ 19:19:22 GMT

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

Anomy Anom wrote:

No, it depends...

All PI columns -> Group By

Lots of rows per AMP per value -> Group by

Up to a few rows per AMP per value -> Distinct

And remember, that a subquery is distinct by default, but you can override it with group by .

Distinct returns an ordered result set, group by doesn't.

AFAIK there's already an enhancement request for that :-)

Dieter

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