I think you would have to agree that calculating the subtotal was easy to do. The results should look like Figure 1.įigure 1: The partial results of the sales orders queries The first query lists the sales orders, and the second query also has a sub total for each customer. I’m running SQL Server 2019 CTP 2.2, and the database is in 2016 compatibility mode. The Performance of Window Aggregates Revisited with SQL Server 2019 - Simple Talk
0 Comments
Leave a Reply. |