SQL语句请教

Question

select name,year,sum(date) as 年数量和
from table
group by name,year

Answer 1

select name,year,sum(date) 年数量和 from 表 group by name,year

Answer 2

select name,year,month,sum(data) All from table group by name,year,month

Answer 3

select name,year,sum(date) as 年数量和
from table
group by name,year

Answer 4

select name,[month],[year],sum(data) as '月统计' from data
group by name,[month],[year]

Answer 5

select name,[year],[month],sum(data) month_sum from table group by name,[year],[month]
我试了可以

Answer 6

select name,year,month,sum(data) Sum_Data
from tablename
group by name,year,month
order by name,year,month

Answer 7

select name,month,year,sum(data)
from tab
group by name,year,month
order by name,year,month

Answer 8

declare @SumData table(name varchar(10),month varchar(2),year varchar(4),data int)insert @SumData select 'mike','1','2001',89
insert @SumData select 'mike','1','2001',60
insert @SumData select 'mike','2','2001',89
insert @SumData select 'mike','2','2001',70
insert @SumData select 'mike','12','2001',76
insert @SumData select 'linda','1','2001',60
insert @SumData select 'linda','1','2001',67select * from @SumData
select name,year,month,sum(data) Sum_Data
from @SumData a
group by name,year,month
order by name,year,month
直接在“查询分析器”中运行！