SqlServer开窗函数

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开窗函数

标签：