Archives of the TeradataForum

Message Posted: Mon, 24 Oct 2011 @ 19:51:30 GMT

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

Aiiii, why are you using TOP? Ok, so how 'bout:

     SELECT blah-de-blah
       FROM blah-de-blah
      WHERE party_id IN (SELECT party_id
                           FROM blah-de-blah
                          HAVING COUNT(*) > 1)

Seems pretty simple.

iv

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