回复：请问 SQL 高手

就是这样吧:
select orderid,storeid,itemid,sum(quantity)
from Table
group by orderid,storeid,itemid
order by orderid,storeid,itemid