回複：請問 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

請您先登陸，再發跟帖！