Archives of the TeradataForum

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

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

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>>