Archives of the TeradataForum

Message Posted: Tue, 07 Jun 2005 @ 17:49:00 GMT

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

You can concatenate the columns...

     SELECT COUNT(DISTINCT COLUMN_A||COLUMN_B||COLUMNS_C)
        FROM TABLE WHERE X=Y;

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