Archives of the TeradataForum

Message Posted: Mon, 24 Oct 2011 @ 21:03:14 GMT

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

You want to use QUALIFY, not HAVING:

     QUALIFY COUNT(*) OVER (PARTITION BY T1.PARTY_ID) > 1

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