SQL問題

Question

name      num      date
a                  4          2009 
a                  5         2009
b                  3         2009
b                  3         2009
c                  2         2008
c                  1         2008怎輸出如下？name      num       date
a                  9          2009
b                 6           2009
c                 3            2008

Answer 1

select name,sum(num) as num,date from $table 
where 1
group by name