Sql Group by 出问题了

SELECT I.S_FeeText,
SUM(I.F_PayMoney) AS F_FeeMoney
,T.DT_DataTime 

from dbo.T_FeeDocItem AS I INNER JOIN
  dbo.T_FeeDocTitel AS T ON T.S_SerialNO = I.S_SerialNO
GROUP BY I.S_FeeText,T.DT_DataTime

结果

杂支 65.000 2010-04-07 10:11:32.860
杂支 3.000 2010-04-07 11:02:26.187
杂支 53.000 2010-04-07 12:58:34.313
广告费 15.000 2010-04-13 11:45:54.797

按理说我要的结果应该是只有 杂支 和 广告费 这两项，请问各位，这是怎么回事。请指点，多谢！！！！！！

---

SELECT I.S_FeeText,
SUM(I.F_PayMoney) AS F_FeeMoney
,CONVERT(varchar(10),T.DT_DataTime, 23) from dbo.T_FeeDocItem AS I INNER JOIN
  dbo.T_FeeDocTitel AS T ON T.S_SerialNO = I.S_SerialNO
GROUP BY I.S_FeeText, CONVERT(varchar(10),T.DT_DataTime, 23)

---

SELECT I.S_FeeText,
SUM(I.F_PayMoney) AS F_FeeMoney
,T.DT_DataTime 

from dbo.T_FeeDocItem AS I INNER JOIN
  dbo.T_FeeDocTitel AS T ON T.S_SerialNO = I.S_SerialNO
GROUP BY I.S_FeeText,T.DT_DataTime


你的SQL语句里面有DT_DataTime这个列啊，删除就可以了！

SELECT I.S_FeeText,
SUM(I.F_PayMoney) AS F_FeeMoney

from dbo.T_FeeDocItem AS I INNER JOIN
dbo.T_FeeDocTitel AS T ON T.S_SerialNO = I.S_SerialNO
GROUP BY I.S_FeeText,T.DT_DataTime

---

你三个“杂支”对应了不同的T.DT_DataTime，当然会出现三行了。

---

引用

SE