Archives of the TeradataForum
Message Posted: Thu, 03 Feb 2011 @ 19:46:10 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|