7,714
社区成员
发帖
与我相关
我的任务
分享关于Access 分组排序的问题
发现 Access 的在分组后的排序有问题,
下面这个语句竟然提示错误：
select barcode,sum(InAmount) as Amount
from indetail
group by barcode
order by Amount
错误提示为：参数 Amount 没有默认值
下面这个语句竟然提示错误：
select barcode,sum(InAmount) as Amount
from indetail
group by barcode
order by Amount
错误提示为：参数 Amount 没有默认值
...全文
请发表友善的回复…
发表回复
changechange 2004-01-16
- 打赏
- 举报
select barcode,sum(InAmount) as Amount
from indetail
group by barcode
order by sum(InAmount)
from indetail
group by barcode
order by sum(InAmount)
wydpz 2004-01-16
- 打赏
- 举报
修改为以下试试看：
select barcode,sum(InAmount) as Amount
from indetail
group by barcode
order by sum(InAmount)
select barcode,sum(InAmount) as Amount
from indetail
group by barcode
order by sum(InAmount)
jiezhi 2004-01-16
- 打赏
- 举报
語法這麼要求的。排序的字段必須是那個表中的字段,且不使用別名。
searoom 2004-01-16
- 打赏
- 举报
asdfs
searoom 2004-01-15
- 打赏
- 举报
为什么排序的时候不能使用别名呢？
