请教关于Sql的问题，谢谢！

jihuoma　发表于：2015-03-17 15:58:10 　

复制

点击下载此附件

Top

cspa 发表于：2015-03-17 16:38:22

供参考：

在access中建立查询：

SELECT First(Sheet1.Dep) AS Dep, First(Sheet1.QQ) AS QQ, Sheet1.HQ, Sum(Sheet1.ZL) AS ZL, Sum(Sheet1.CF) AS CF, Sum(Sheet1.GH) AS GH, Sum(Sheet1.ZY) AS ZY, Sum(Sheet1.HL) AS HL, Sum(Sheet1.ZH) AS ZH, Sum(Sheet1.ZR) AS ZR, Sum(Sheet1.DC) AS DC
FROM Sheet1
GROUP BY Sheet1.HQ;

点击下载

Top

jihuoma 发表于：2015-03-17 17:31:51

非常感谢cspa老师的解答，虽然我是在sql中没有first函数，但老师给的范例很好，问题解决了。

Top

总记录：2篇页次：1/1 9 1 :

Access交流中心

请教关于Sql的问题，谢谢！