SQL2005 求和的问题

Question

现在又一个表A，数据如下

MO              NE           TIME

324         SZM1B1      2010-08-03 10：00：00

123         SZM1B1      2010-08-03 16：00：00

53           SZM1B1      2010-08-03 22：00：00

我想根据NE 和 TIME的DATE对MO列求和

Answer 1

select sum(mo) as mo_sum

from A

group by NE,convert(varchar(10),TIME,120)

 

---

family as water

Answer 2

select convert(varchar(10),TIME,120) as [DATE] ,sum(MO) as s_mo

from a

group by convert(varchar(10),TIME,120)

Answer 3

感谢 ，前2回复是我自己弄错了