Archives of the TeradataForum
Message Posted: Mon, 09 Jan 2012 @ 15:48:59 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|