多項(xiàng)選擇題

以下關(guān)于COMPUTE和COMPUTE BY的SQL語(yǔ)句錯(cuò)誤的是()。

A.SELECT * FROM [order details] ORDER BY Product ID ,Employeeid COMPUTESUM(quantity)
B.SELECT * FROM [order details] ORDER BY Product lD ,Employeeid COMPUTESUM(quantity)BY ProductID
C.SELECT * FROM [order details] ORDER BY Product ID ,Employeeid COMPUTESUM(quantity)BY Employeeid
D.SELECT * FROM [order details] ORDER BY Product ID ,Employeeid COMPUTESUM(quantity)BY Employeeid ,Product ID


微信掃碼免費(fèi)搜題