我是一名学生开发者,目前正在学习SQL课程。我正在尝试从表中检索多个行组的总和。我对SQL开发非常陌生,对于以下情况我不太确定问题出在哪里。我有一个大表格,我想从中选择特定的行,然后添加余额列。
以下查询不会显示任何结果,我不太确定原因。我有一个猜测,即between语句每个表只能使用一次,但也许我错了?
Select Description, SUM(Balance) AS Total_Balance
FROM Chart_Of_Accounts
WHERE (Account BETWEEN ('400401') AND ('400407'))
AND (Account BETWEEN ('440094') AND ('440100'))
AND (Account BETWEEN ('450094') AND ('450100'))
GROUP BY Description, Balance
2012年10月1日编辑 根据(Richard aka cyberkiwi)的要求
我所拥有的内容
Set 1
|Account |Description |Balance
|4004xx |Red Wine |$2361.23
|4004xx |White Wine |$3620.23
|4004xx |Rice Wine |$1223.23
Set 2
|Account |Description |Balance
|4400xx |Red Wine |$4361.23
|4400xx |White Wine |$3260.23
|4400xx |Rice Wine |$223.23
Set 3
|Account |Description |Balance
|4500xx |Red Wine |$1361.23
|4500xx |White Wine |$1620.23
|4500xx |Rice Wine |$1223.23
我想要实现的结果
Total
|Description |Total_Balance
|Red Wine |$8083.69
|White Wine |$8500.69
|Rice Wine |$2669.69
感谢您阅读我的帖子! 我也很愿意接受有关SQL开发的建议, 并且非常感激任何反馈。