代码:
create view good_total
as
select gid,sum(quantity) total
from sale_recorder
where sale_date between '2010-04-01' and '2010-07-31'
group by gid
ps:
sum()
代码:
create view good_total
as
select gid,sum(quantity) total
from sale_recorder
where sale_date between '2010-04-01' and '2010-07-31'
group by gid
ps:
sum()