Archives of the TeradataForum

Message Posted: Tue, 22 Feb 2005 @ 14:19:18 GMT

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

Try using the MDIFF (x,w,y) or SUM (preferred) functions:

     MDIFF (value_expression, width, sort_expression_list)

or

     X - SUM( X ) over (order by Y rows between W preceding and W preceding)

Wayne Schachtel
Wayne Schachtel Consulting

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