3 ms·
This article enlightened me on the underlying logic, as well as some different implementations. https://modern-sql.com/use-case/pivot https://modern-sql.com/use
by reilly3000 8y ago
This article enlightened me on the underlying logic, as well as some different implementations. https://modern-sql.com/use-case/pivot https://modern-sql.com/use-case/pivot
- nevi-me 8y agoI was lazy to add its link, that's where I learnt about the proprietary implementations of various databases. I wonder if we'll ever get an ANSI-2019 SQL version that tries to merge what various DB vendors have branched off and done. Maybe it already exists? https://www.whoishostingthis.com/resources/ansi-sql-standards/ https://www.whoishostingthis.com/resources/ansi-sql-standard...