Archives of the TeradataForum

Message Posted: Wed, 22 Oct 2003 @ 14:08:05 GMT

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

Correct. The ODBC spec does not support the WITH clause since it is a Teradata specific extension to SQL.

The only (partial) solution currently is to use the 'Add Totals' menu in SQL Assistant ... but this only adds grand totals to the result set.

You can view the Sum (or Average, Standard Deviation, or Variance) of a column (or any block of cells) by highlighting them and looking at the status bar. (Use Alt, Shift, and Ctrl for the other aggregate types)

When you upgrade to Teradata V2R5.1 you will be able to use the 'Group By Rollup()' clause to create a report that contains aggregate values at any level. This is effectively an 'ANSI standard' equivalent of the WITH clause.

Mike Dempsey
Teradata Client Tools

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