sqlcmd.net validated sql reference

Tag archive

#subtotals

Commands grouped around the same concept, pattern, or recurring problem.

1 commands with this tag Browse related patterns quickly
intermediate aggregation MySQL MariaDB SQL Server PostgreSQL

Add Subtotals and a Grand Total With ROLLUP

Use `GROUP BY ROLLUP` to produce subtotals and a grand total alongside regular grouped rows in one query.