Re:SQL Pivot: Converting Rows to Columns
by reilly3000 on Thursday November 01, 2018 @12:56PM
(#18355984)
This article enlightened me on the underlying logic, as well as some different implementations. https://modern-sql.com/use-case/pivot
[ Parent
| on HN ]
Re:SQL Pivot: Converting Rows to Columns
by nevi-me on Thursday November 01, 2018 @01:11PM
(#18356154)
I 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-standard...