Here's how GROUP BY works differently across SQL dialects
It turns out I've been writing longer queries than I should.π Here's an interesting gotcha about GROUP BY between SQL dialects that I've just learned.
So I've started with SQL Server back in the day, where according to docs:
a GROUP BY column expre...
datawise.dev2 min read