WITH TopSales (SalesPersonID,TerritoryID , NumberOfSales)/*定义*/
AS
(
SELECT SalesPersonID,TerritoryID, COUNT(*)
FROM Sales.SalesOrderHeader
GROUP BY SalesPersonID,TerritoryID
)
SELECT * FROM TopSales
WHERE SalesPersonID IS NOT NULL
ORDER BY NumberOfSales DESC
sql server 2008 通用表达式CTE
最新推荐文章于 2024-01-15 09:34:05 发布