SqlServer union all使用方法

在SqlServer中使用union all 查询两个sql的合并结果，sql 如下

select top 1 sdtPeriod from tbfundportionassistant as p  ORDER BY p.sdtPeriod
UNION ALL
select top 1 sdtPeriod from tbfundportionassistant as p  ORDER BY p.sdtPeriod ;

运行后报错，提示UNION ALL处有语法错误，查询资料后，发现只需要排序一次即可：

select top 1 sdtPeriod from tbfundportionassistant as p  
UNION ALL
select top 1 sdtPeriod from tbfundportionassistant as p  ORDER BY p.sdtPeriod ;