Archives of the TeradataForum

Message Posted: Wed, 12 Apr 2006 @ 12:22:15 GMT

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

<-- Anonymously Posted: Wednesday, April 12, 2006 08:26 -->

CSUM is discouraged; it's Teradata-only syntax and could be removed in the future.

How about the ROW_NUMBER ordered analytic function? Or windowed COUNT(*) which is equivalent to ROW_NUMBER. Or windowed SUM which is equivalent to CSUM?

There are lots of other tricks in the archives...

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