News for hackers. Stuff that matters.

A comment on The Curious Case of the Aggregation Query. Parent comment

Re:The Curious Case of the Aggregation Query by marcosdumay on Tuesday December 05, 2023 @11:57AM (#38533474)
Not writing `group by` is the same as writing `group by ()`.

And yeah, the difference between that and a value is one of those really surprising things on SQL that actually make sense and should be this way. Unfortunately, there are many of those.

[ Parent | on HN ]
Re:The Curious Case of the Aggregation Query by foldU on Tuesday December 05, 2023 @11:59AM (#38533507)
Ah my apologies, I wasn't familiar with that syntax.
[ Parent | on HN ]
Re:The Curious Case of the Aggregation Query by marcosdumay on Tuesday December 05, 2023 @01:13PM (#38534748)
No need to apologize. My post didn't make that clear at all.
[ Parent | on HN ]