Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 04 Sep 2009 @ 19:13:54 GMT


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


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023