News for hackers. Stuff that matters.

A comment on Challenges students face when learning to work with relational databases and SQL. Parent comment

Re:Challenges students face when learning to work with relat... by fifilura on Monday August 30, 2021 @05:53AM (#28354165)
What I think you'd do here (in modern implementations of SQL at least) is to split the values into an array using some convenient split function and self join on that array to pivot the arrays into rows.
[ Parent | on HN ]
Re:Challenges students face when learning to work with relat... by magicalhippo on Monday August 30, 2021 @08:42AM (#28355041)
> some convenient split function

If only the DB we're using had one of those :)

[ Parent | on HN ]