4/30/2023 0 Comments Invoice subtotal vs grandtotalDisplaying the higher aggregation levels using a GROUPING SETS clause You only see the totals for Make, Color, and the grand total, as you can see in Figure 4.įigure 4. GROUP BY GROUPING SETS ((MakeName), (Color), ()) For instance, if you alter the GROUP BY clause in this example so that it reads
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |