Archives of the TeradataForum

Message Posted: Tue, 01 Jul 2003 @ 09:53:31 GMT

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

Good one Andy

Andy's workaround is cool.

It should be noted that if the PI_COLUMN(s) is non-unique then the query could return more than five rows, but that is where your extra condition would/could come in.

Cheers

Jon

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