SQL 按降序列出总订单 [英] SQL List total orders in descending order

问题描述

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 子句上遇到语法错误.我不确定语法错误是什么.

Im trying to list the total number of orders by customer in descending order. I get a syntax error on the group by clause. Im not sure what the syntax error is.

推荐答案

您缺少 ORDER BY 子句.您的查询应如下所示:

You're missing your ORDER BY clause. Your query should look like:

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;

这篇关于SQL 按降序列出总订单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！