Archives of the TeradataForum
Message Posted: Fri, 04 Sep 2009 @ 19:08:26 GMT
| 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 >
Dieter
| 
