Archives of the TeradataForum
Message Posted: Thu, 29 Jul 2004 @ 21:13:05 GMT
<-- Anonymously Posted: Thursday, July 29, 2004 17:04 -->
Thanks for looking in to this.
Derived table logic mentioned below won't work. In the derived table, we are grouping by div, cd1, typ ,id.
we can have same id for div , typ combination for different cd1.
In the lvltyp column, I would like to get count on distinct id.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|