You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
IMO grouping by an alias is the way to go. No need to repeat a lengthy expression. It makes the code more compact and readable. Using a positional reference is bad for the same reason as stated in G-3180.
The text was updated successfully, but these errors were encountered:
Starting with 23c it is possible to group by column alias or position.
IMO grouping by an alias is the way to go. No need to repeat a lengthy expression. It makes the code more compact and readable. Using a positional reference is bad for the same reason as stated in G-3180.
The text was updated successfully, but these errors were encountered: