Archives of the TeradataForum

Message Posted: Thu, 29 Jul 2004 @ 21:13:05 GMT

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

<-- 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.

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