SQL
SQL pivot tables: CASE WHEN, COUNT and the traps around NULL
A pivot can look correct while losing orders. I show how to count categories, distinguish zero from missing data and reconcile the columns with the source.
Tag
pivot table sql
KajoData articles about pivot table sql. Practical knowledge about data analysis, tools and careers.
Articles: 1