Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 04 Sep 2009 @ 19:08:26 GMT

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

Subj:   Re: Volatile tables in macros
From:   Dieter Noeth

Shrihari Saraf wrote:

  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.  

Any application expecting data to be returned in any special order without ORDER BY is doomed. And what is so complex about adding an ORDER BY?

  So there is no work around?.  

No. A set of data in a relational databases is always unordered, this is one of the basic RDBMS principles.

  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.  

If Oracle and DB2 return the data in the expected order you just got luck. This behaviour might change with the next release, MS SQL Server just did that.

< mantra > there's no order in a relational database < /mantra >


  <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