How to group over nothing/group the whole table #1276
CelebrateVC
started this conversation in
Polls
Replies: 1 comment
-
Why not |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
RE #1229 (and associated #1230 draft PR) I took a close look at the group by behaviors of Surreal. in 1230 @tobiemh mentioned the need for discussion around how to group by nothing allowing for aggregation of the whole table right now in various tests, this is done by
GROUP BY ALL
in a situation where columnALL
does not exist in the data.If
ALL
would exist for a few records then that would be grouped separately after 1230, which aims to allow grouping of columns even if they are not used in the fields of the select (and has since extended toorder
(#1233),split
, andfetch
clauses as well)The common way grouping the whole table is done in my experience is
group by <static value>
(1 or null or whatever) however all static values are possible column names.1 vote ·
Beta Was this translation helpful? Give feedback.
All reactions