Archives of the TeradataForum

Message Posted: Mon, 09 Jan 2012 @ 15:48:59 GMT

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

PARTITION BY RANGE_N is probably the more commonly used partitioning expression, but CASE_N is used to define a partitions on data based on an associated condition. It's similar to the CASE expression used in SQL statements.

You probably want to check out the Teradata Database Design manual and look at the section titled "Considerations for Basing the Partitioning Expression on the CASE_N function" section.

Regards,

Jason Swartzbaugh
Solution Architect
Teradata Government Systems

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