Archives of the TeradataForum

Message Posted: Wed, 16 Jul 2003 @ 08:23:31 GMT

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

A COUNT will always return a row (with 0 in it if no rows). If you generally expect no rows, why don't you just use 'Sel * from .... ' (or select the max of one of the column values within ..)

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