7 ms·
Can't you use an alias in a group by?
by oweiler 5y ago
Can't you use an alias in a group by?
- icambron 5y agoSome DBs let you do this and it's helpful when one of the things you're selecting is some complex scalar expression, but you still have to list each item in the group by
- Sesse__ 5y agoNot by the SQL standard, since projection (which creates aliases) happens after aggregation. There are many databases that allow it as an extension, though.