SqlServer开窗函数
时间：2021-07-01 10:21:17
帮助过：2人阅读
productNo,productName,price,amount,
ROW_NUMBER() over(partition
by productNo
order by amount) rowNo,
SUM(amount)
over(partition
by productNo) totalAmount,
MAX(price)
over(partition
by productNo) maxPrice
from product
SqlServer开窗函数
标签：
