- /*
- 查询销量前10名的产品名称
- */
- USE Northwind
- -- 采用子查询的方式
- SELECT p.ProductID, p.ProductName
- FROM Products AS p
- WHERE p.ProductID IN
- (
- SELECT p_top10.ProductID FROM
- (
- SELECT TOP 10 ProductID, SUM(Quantity) AS TotalQuantity
- FROM [Order Details] AS od
- GROUP BY ProductID
- ORDER BY TotalQuantity DESC
- ) AS p_top10
- )
- -- 采用表连接的方式
- SELECT p.ProductID, p.ProductName, od_Top10.TotalQuantity
- FROM Products AS p join
- (
- SELECT TOP 10 ProductID, SUM(Quantity) AS TotalQua
T-SQL 查询销量前10名的产品名称
最新推荐文章于 2023-03-16 11:50:13 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)