sqlserver排序问题，如何保存

Question

select * from 矿石生产
order by [DEPARTMENT_NAME] asc, [REPORT_DATE] asc, [INDEX_ID] asc
这样查询的结果是我想要的顺序，如何保存呢？
select * into tableB from 矿石生产
order by [DEPARTMENT_NAME] asc, [REPORT_DATE] asc, [INDEX_ID] asc
为什么tableB中显示的不是我想要的顺序啊？

Answer 1

select * into tableB from （select * from 矿石生产
order by [DEPARTMENT_NAME] asc, [REPORT_DATE] asc, [INDEX_ID] asc）就行了