Archives of the TeradataForum

Message Posted: Fri, 19 Oct 2007 @ 10:39:03 GMT

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

Hi,

what about

     insert into new_table
     select col1, col2, ..., colN
     from oldtable
     group by col1, col2, ..., colN;

Just a simple "group by", no window aggregates, ....

BR

Christian

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