|
|
Archives of the TeradataForum
Message Posted: Mon, 24 Feb 2004 @ 04:28:50 GMT
Subj: | | Re: Intense Query question |
|
From: | | Dennis Calkins |
On Mon, 23 Feb 2004 15:51:01 -0600, Berg, John wrote:
| Ok.. Got a little brain teaser for the list. I have a way to work it, but it certainly is not efficient. | |
| This would work great in a multi-dimensional cube, however I have to process this in SQL. | |
| Any creative suggestions? | |
Upgrade to v2r5.1 and use one of the new Extended Grouping Qualifiers
Cube, Grouping Sets, and Rollup
Teradata RDBMS SQL Reference: Data Manipulation Statements ( v2r5.1 ) Chapter 1
www.info.ncr.com/eDownload.cfm?itemid=033360019
| |