为什么SUM(Sold)给我的结果与手动对该字段求和不同?如果我手动对Sold字段求和,这是给我正确的查询:SELECTCustCode,FiscalYear,SoldFROMDBNAME.dbo.SALESDETAILWHERE(FiscalYear=YEAR({fnNOW()}))andCustCode='248'GROUPBYCustCode,FiscalYear,Sold但是如果我尝试使用SUM函数,我会得到错误的金额。谁能帮帮我?SELECTCustCode,FiscalYear,SUM(Sold)FROMDBNAME.dbo.SALESDETAILWHERE(FiscalY