Archives of the TeradataForum

Message Posted: Sat, 25 Jun 2011 @ 14:36:10 GMT

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

<-- Anonymously Posted: Saturday, June 25, 2011 08:14 -->

Hi

Would there be a simple way to use group by all columns in TD SQL?? Say if i have large number of cols. I don't wish to use DISTINCT.

Ex:

     select a,b,c,d,e...z  from table group by 1..26
     select a,b,c,d,e...z  from table group by 1-26
     select a,b,c,d,e...z  from table group by ALL

Thanks

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