Archives of the TeradataForum
Message Posted: Fri, 04 Sep 2009 @ 19:13:54 GMT
| Subj: | | Re: INSERT into table with select Order by clause |
| |
| From: | | Victor Sokovin |
You somehow posted this under the subject in parallel thread. I changed it back to
Re: INSERT into table with select Order by clause
| | Thanks for the reply. I need to have "order by" clause in the insert statement. This is the basic logic we used in our application,
based on the order by output we do further actions. If I remove the order by clause I have to re-write complete application code. So there is no
work around?. I try using "create table...index order by values " this also doesn't give me the output in order by.
Basically what I need to have table with data coming from other table and the data in the new table should be sorted for a specified column. Let
me know if there are any command to sort the table and store the result in same table. | |
No luck with sorting the table, as explained earlier in the thread, but check out the discussion in which Joerg was trying to make the view do
the similar ORDER BY job:
www.teradataforum.com/teradata/20080125_195650.htm
Perhaps you can introduce similar views in your application.
Victor
| 
