 |
 |
Archives of the TeradataForum
Message Posted: Fri, 12 Jan 2007 @ 13:11:41 GMT
| Subj: | | Re: ORDER BY in INSERT SELECT to GENERATE Sequence |
| |
| From: | | Michael Larkins |
I would try the Row_number OLAP function in the select. It will order the values and assign the sequential number. I have never tried these
in an insert select - my guess is that it would work because the sort is internal to the function and works with a derived table.
Regards,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |
