Archives of the TeradataForum

Message Posted: Thu, 03 Feb 2011 @ 19:46:10 GMT

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

Hi,

I want to avoid this distinct in the below query:

     Select c1, sum(c2), count(c2),count(distinct c4)
         from ss_tst group by c1

Is there a way to avoid this distinct? My actualy query is very complex with lot many group by columns, creating a sub-query may not be a good option.

Regards,

Soumya

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