Archives of the TeradataForum

Message Posted: Thu, 28 Oct 2010 @ 09:52:01 GMT

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

     SELECT HASHAMP(HASHBUCKET(HASHROW())) AS "AMP#", COUNT(*)
     FROM  GROUP BY 1 ORDER BY 2 DESC;

HASHROW - returns the row hash value for a given value

HASHBUCKET - the grouping of a specific hash value

HASHAMP - the AMP that is associated with the hash bucket

Regards

Minakshi Swami

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