回复：请问 SQL 高手

来源: tapisapi2008 于 2009-06-18 18:12:32 [] [旧帖] [给我悄悄话] 阅读数 : (142 bytes)

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

请您先登陆，再发跟帖！