-
-
Notifications
You must be signed in to change notification settings - Fork 5
Add DISTINCT to GROUP BY #1069
Copy link
Copy link
Open
Labels
Description
Activity
Metadata
Metadata
Assignees
Labels
Type
Projects
- StatusShow more project fields✅ Done
If these duplicates are undesirable, they can be removed using the DISTINCT clause directly on the GROUP BY. Therefore:
GROUP BY DISTINCT ROLLUP (a, b), ROLLUP (a, c)is equivalent to