Aaron Bertrand wants a feature:
GROUP BY
queries can become overly convoluted if your grouping column is a complex expression. Because of the logical processing order of a query, you’re often forced to repeat such an expression since its alias can’t be used in theGROUP BY
clause.Oracle recently solved this in their 23c release by adding the ability to
GROUP BY column_alias
. This is such simple but powerful syntax, and I’m hoping we can get SQL Server to follow Oracle’s lead.
This would be a pretty nice feature. Admittedly, the workarounds aren’t that difficult, but this would be a nice quality of life update.