如果一个表是这样的
表头: NAME count DATE
内容: A 2 2005-11-10
A 1 2005-12-13
A 5 2005-12-17
A 7 2005-12-17 B 5 2005-12-17
B 4 2005-12-17
我现在要变成: A 13 12(指月份为12月)
B 9 12
该怎么做啊 ,要SQL语言怎么做 谢谢拉
表头: NAME count DATE
内容: A 2 2005-11-10
A 1 2005-12-13
A 5 2005-12-17
A 7 2005-12-17 B 5 2005-12-17
B 4 2005-12-17
我现在要变成: A 13 12(指月份为12月)
B 9 12
该怎么做啊 ,要SQL语言怎么做 谢谢拉
select [name],month([date]) as imonth,sum(count) as icount
from tablename group by [name],imonth
--------------------------------------------
小兔子:
你在偷懒 这个基本什么没做 而且GROUP BY 还 WHERE
还继续什么?
难道我那句SQL语句有问题吗?
Select Name,Sum(Count) AS Count,Month(Date) AS Month From Table1 Group By Name Where Year(Date)=Year(Date()) AND Month(Date)=Month(Date())
由于COUNT是关键字,所以请加上中括号,建议不要用count,date这些跟关键字有关的作字段名。