Rajendra Gupta uses a reducer function:
SQL Server 2025 includes new features and enhancements. In the previous SQL Server 2025 tips, we have explored many new features. Have you explored the new Product() function? If not, this will walk you through the Product() function with several examples.
Read on to see how PRODUCT() works and how thoughtful the development team was around supporting window functions as an aggregate function.