sql - 从 union 语句中删除默认 order by

Question

我想显示这样的数据:

Column1        Column2
-----------------------
TotalAvg         60%

A1               50%

B1               70%

Z1               60%

我的sql脚本是这样的:

select 'Total Avg' as Column1,'60%' as Column2

union

select Column1,Column2 from tblAvg

我得到的结果是这样的:

Column1        Column2
------------------------

A1               50%

B1               70%

TotalAvg         60%

Z1               60%

问题:我想删除默认排序并希望结果符合我们正在创建联合表的顺序。

Answer 1

您可以添加指定结果顺序的列:

select 'Total Avg' as Column1,'60%' as Column2, 1 as OrderCol
union
select Column1,Column2, 2 from tblAvg
order by OrderCol

如果没有order by，数据库可以自由地以任何顺序返回行。