34,593
社区成员
发帖
与我相关
我的任务
分享在SQL SERVER所带的Northwind中，查询当前各类别的产品金额汇总？
在SQL SERVER所带的Northwind中，查询当前各类别的产品金额汇总？
---------------------
|CategoryName | 合计 |
---------------------
SqlCommand:
SELECT CategoryName = min(Categories.CategoryName),
SUM(Products.UnitPrice * Products.UnitsInStock) AS Total
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
GROUP BY Categories.CategoryID
请问这条SQL查询语句对不对？如有错误请指正！
谢谢！
---------------------
|CategoryName | 合计 |
---------------------
SqlCommand:
SELECT CategoryName = min(Categories.CategoryName),
SUM(Products.UnitPrice * Products.UnitsInStock) AS Total
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
GROUP BY Categories.CategoryID
请问这条SQL查询语句对不对？如有错误请指正！
谢谢！
...全文
请发表友善的回复…
发表回复
zjcxc 元老 2004-04-04
- 打赏
- 举报
没什么问题.
