日期:2014-05-18 浏览次数:20438 次
select sum(出货数量) from A where 售货员 in ('a','b' ) and 出售物品 = 'c' and (时间 between '2011-11-01' and '2011-11-30' )
------解决方案--------------------
select 售货员,sum(出货数量) from A where 售货员 in ('a','b' ) and 出售物品 = 'c' and (时间 between '2011-11-01' and '2011-11-30' ) group by 售货员