Archives of the TeradataForum
Message Posted: Fri, 12 Jan 2007 @ 11:28:38 GMT
<-- Anonymously Posted: Friday, January 12, 2007 05:52 -->
When we try to do the below INSERT.. SELECT
Insert into temp2 (value1, value2, value3) As Select (value1, valu2, value3) from temp1 order by value1
We get the following error
"3706: ORDER BY IS NOT ALLOWED IN SUB QUERIES"
I understand ORDER BY can't exist in the sub query.
But our intention is to generate a sequence number (in temp2) based on the 'value1' column in some order.
Can some one tell us, how to accomplish this ?
Thanks in advance
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|