ms-access - 在 Microsoft Access 中使用顺序

Question

我在访问中有一个名为 DUAL 的表。

我的查询是：

select * from 
(select val(1) as NO from dual
union all
select val(3) as NO from dual
union all
select val(2) as NO from dual) a
order by No

结果 ：

NO
2
3
1

为什么Order By No运行不好？

我想要的结果是

NO
1
2
3

非常感谢你

标签： ms-access

Answer 1

我猜 NO 是保留字，不需要外部查询，因此：

select val(1) as [NO] from dual
union all
select val(3) as [NO] from dual
union all
select val(2) as [NO] from dual
order by [NO]