Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 04 Sep 2009 @ 15:45:08 GMT


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


Subj:   Re: Volatile tables in macros
 
From:   Shrihari Saraf

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.


Regard,

Shri



     
  <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