现在显示的是这个效果select
SupplierCategory as 供应商分类,
Number as 数量
from SupplierInfo,OrderDetail
where OrderDetail.SupplierId=SupplierInfo.SupplierId
and SupplierCategory=5这是我写的查询语句我想请问一下 怎么才能让 相同供应商的数量全部加起来?
解决方案 »
- 求sql语句一条
- create一个函数返回一个update的值该怎么写
- Microsoft SQL Server 2005 在复制拓扑中可以包含从 Oracle 8.0.5 版本开始的 Oracle 发布服务器。
- 服务器: 消息 170,级别 15,状态 1,行 18..郁闷。
- 请教一个查询语句,在线等待
- 如何接受存储过程返回的表?
- 【监测】如何监测sql server 2000
- 服务器: 消息 245,级别 16,状态 1,行 1将 varchar 值 '41----' 转换为数据类型为 int 的列时发生语法错误。
- 请教数据插入问题?
- 连接SQL SERVER服务器的问题
- 问个自编号问题
- 求一SQL语句
SupplierCategory as 供应商分类,
sum(Number) as 数量
from SupplierInfo,OrderDetail
where OrderDetail.SupplierId=SupplierInfo.SupplierId
and SupplierCategory=5
SupplierCategory as 供应商分类,
sum(Number) as 数量
from SupplierInfo,OrderDetail
where OrderDetail.SupplierId=SupplierInfo.SupplierId
and SupplierCategory=5
group by SupplierCategory
from SupplierInfo,OrderDetail
where OrderDetail.SupplierId=SupplierInfo.SupplierId and SupplierCategory=5
group by SupplierCategory
SupplierCategory as 供应商分类,
sum(Number) as 总数量
from SupplierInfo,OrderDetail
where OrderDetail.SupplierId=SupplierInfo.SupplierId
group by SupplierCategory
非常感谢你 不过朋友能不能再请教一下
select
SupplierName as 供应商名字,
SupplierCategory as 供应商分类,
sum(Number) as 数量
from SupplierInfo,OrderDetail
where OrderDetail.SupplierId=SupplierInfo.SupplierId
and SupplierCategory=5
group by SupplierName现在这样不行了
他说我选择列表中的列 'SupplierInfo.SupplierCategory' 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中。 麻烦了 分给你了