|
|
Archives of the TeradataForum
Message Posted: Wed, 03 May 2006 @ 09:53:38 GMT
Subj: | | Re: Need Help Writing SQL |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, May 03, 2006 03:53 -->
| The unique problem could be if col3 for a col1 has the value = 8 then you could not distinguish if the 8 stay for distinct values or all
values = 8 | |
Also, if a particular col1 had a col3 value of anything other then 1 or 2, it will not generate the required col4, thus:
col1 col2 col3 Required Result
456 987 3 3 8
456 765 3 3 8
456 654 3 3 8
The Ordered OLAP soln. gives the correct col4 value, i.e. 8 for the example above.
Best Regards
| |