阿摩線上測驗
Order資料表經SQL執行之後的結果如下所示，下列那一項SQL語法執行後可得到這樣的結果？
( A )SELECT Region_name, Total FROM Order GROUP BY Quantity
( B )SELECT Region_name, SUM(Total) FROM Order GROUP BY Quantity
( C ) SELECT Region_name, SUM(Quantity) AS Total FROM Order GROUP BY
Region_name
( D )SELECT Region_name, SUM(Total) FROM Order GROUP BY Region_name
,
| Order資料表經SQL執行之後的結果如下所示，下列那一項SQL語法執行後可得到這樣的結果？ |
| ( A )SELECT Region_name, Total FROM Order GROUP BY Quantity |
| ( B )SELECT Region_name, SUM(Total) FROM Order GROUP BY Quantity |
| ( C ) SELECT Region_name, SUM(Quantity) AS Total FROM Order GROUP BY Region_name |
| ( D )SELECT Region_name, SUM(Total) FROM Order GROUP BY Region_name |
答案：登入後查看
統計： A(5), B(24), C(116), D(15), E(0) #382386
統計： A(5), B(24), C(116), D(15), E(0) #382386
