copy set of data to another table with order by
Hi,
i have this data in the staging table called Stage1. C1,C2 and C3 are column Headers.
C1 C2 C3
41 te cc
51 te cc
42 te cc
41 te cc
51 te cc
42 te cc
41 te cc
51 te cc
42 te cc
Now from this staging table i want to insert into another temp table in the same order but i want to insert row42 after row41. ex: 41,42,51 and again 41,42,51 and so on. If this is the case how do i query to insert into another table.
can you guys help me with the query? appreciate your help
Thx
|