sqlserver選擇題答案-資料下載頁
2025-06-19 14:50本頁面
【正文】 Orders GROUP BY OrderDate,SUM(OrderAmount)FROM Orders GROUP BY C_ID,C_ID3. 列出客戶訂單總金額大于3000的數(shù)據(jù)，正確的SQL是（）A. SELECT C_ID ,SUM(OrderAmount)FROM Orders GROUP BY C_ID HAVVING SUM(OrderAmount)3000B. SELECT C_ID ,SUM(OrderAmount) FROM Orders WHERE SUM (OrderAmoount)3000 GROUP BY C_IDC. SELECT C_ID ,SUM(OrderAmount) FROM Orders WHERE SUM (OrderAmoount)3000 D. SELECT C_ID ,SUM(OrderAmount)FROM Orders GROUP BY C_ID WHERE SUM(OrderAmount)3000“張震東”的訂單總金額，正確的SQL是（）A. SELECT SUM (OrderAmount) FROM Orders o JOIN Customer c ON = WHERE =’張震東’ GROUP BY CustomerIDB. SELECT SUM (OrderAmount) FROM Orders o JOIN Customer c ON = WHERE =’張震東’ GROUP BY OrderDateC. SELECT SUM (OrderAmount) FROM Orders o INNER JOIN Customer c ON = =’張震東’ GROUP BY D. SELECT SUM (OrderAmount) FROM Orders o JOIN Customer c WHERE =’張震東’ GROUP BY ON = GROUP BY OrderDate，正確的SQL是（） , FROM Orders o JOIN Customer c ON = WHERE =’上?！?, FROM Orders o JOIN Customer c WHERE =’上?！?ON = , FROM Orders o JNNER JOIN Customer c ON = AND =’上海’ , FROM Orders o WHERE =’上?！疛OIN Customer c ON =
數(shù)學(xué)相關(guān)推薦
鄂ICP備17016276號-1