SQL List总订单降序

Question

SELECT Customer.CID, Count(Order.OrderID) AS [# Orders] 
FROM Customer INNER JOIN [Order] ON Customer.CID = Order.CID 
Group By Customer.CID DESC; 

我试图按降序排列客户的订单总数。我在group by子句中出现语法错误。林不知道什么语法错误。

Answer 1

您错过了ORDER BY子句。您的查询应该是这样的：

SELECT Customer.CID, Count(Order.OrderID) AS [# Orders] 
FROM Customer INNER JOIN [Order] ON Customer.CID = Order.CID 
GROUP BY Customer.CID 
ORDER BY Customer.CID DESC; 

Answer 2

您应该使用order by，而不是group by。
所以新的查询会，

SELECT Customer.CID, Count(Order.OrderID) AS [# Orders] 
FROM Customer INNER JOIN [Order] ON Customer.CID = Order.CID 
Order By Customer.CID DESC; 

我没有表。所以请提供您的评论。