回複：請問 SQL 高手

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