sqlcmd.net validated sql reference

Tag archive

#reporting

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

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

Calculate A Weighted Average

Divide the sum of value times weight by the sum of weights instead of averaging pre-aggregated values.

advanced windowing MySQL MariaDB SQL Server PostgreSQL

Calculate Percent Of Total With A Window Function

Use `SUM(...) OVER ()` to compare each row's value to the total without collapsing the result set.

intermediate filtering MySQL MariaDB SQL Server PostgreSQL SQLite

Filter A Date Range With A Half-Open Boundary

Use an inclusive start and exclusive end to match a whole date range without missing rows that include times.

intermediate date-time MySQL MariaDB SQL Server PostgreSQL SQLite

Group Rows By Month

Bucket dates into month starts, then aggregate counts or totals per month.

intermediate aggregation MySQL MariaDB SQL Server PostgreSQL

Group Rows By Multiple Columns

Use more than one column in `GROUP BY` when each combination defines a separate aggregate bucket.