In 8.1.6 you can use ORDER BY in (inline) views, and
INSERT INTO tab_a
SELECT * FROM tab_b
ORDER BY col_c
will work.
But why do you want such an insert? You cannot be sure that if you try
SELECT * FROM tab_a
it will be ordered on col_c.
|
Results 1 to 3 of 3
Thread: INSERT Into with Order byThreaded View
|
Click Here to Expand Forum to Full Width |