Hi all,
When we insert a table based on select, then why it change the order of the rows in the new table.
For some reason we do not want to change the rows order
e.g
insert into new_table
(cola,colb,colc)
select col1,col2,col3 from old_table
where -------
and -------;
Thanks




Reply With Quote