![PostgreSQL ALIAS fails in ORDER BY clause of an SQL SELECT when using LOWER() - Queries and Resources - Retool Forum PostgreSQL ALIAS fails in ORDER BY clause of an SQL SELECT when using LOWER() - Queries and Resources - Retool Forum](https://community.retool.com/uploads/default/original/3X/1/d/1d25edeacfb8294c387c7553ae63cbc6995e101f.png)
PostgreSQL ALIAS fails in ORDER BY clause of an SQL SELECT when using LOWER() - Queries and Resources - Retool Forum
![ALIAS is not allowed in HAVING clause, GROUP BY and WHERE clause. Allowed in ORDER BY – 1Z0-061 Oracle SQL ALIAS is not allowed in HAVING clause, GROUP BY and WHERE clause. Allowed in ORDER BY – 1Z0-061 Oracle SQL](http://1z0-061.korobko.pro/wp-content/uploads/2018/02/ALIAS-is-not-allowed-in-HAVING-clause-6.jpg)
ALIAS is not allowed in HAVING clause, GROUP BY and WHERE clause. Allowed in ORDER BY – 1Z0-061 Oracle SQL
![postgresql - Combining multiple SELECT/WHERE into a result with multiple columns with alias names - Database Administrators Stack Exchange postgresql - Combining multiple SELECT/WHERE into a result with multiple columns with alias names - Database Administrators Stack Exchange](https://i.stack.imgur.com/riTzk.png)
postgresql - Combining multiple SELECT/WHERE into a result with multiple columns with alias names - Database Administrators Stack Exchange
![5mins of Postgres E27: Waiting for Postgres 16 - Make subquery alias optional in FROM clause - YouTube 5mins of Postgres E27: Waiting for Postgres 16 - Make subquery alias optional in FROM clause - YouTube](https://i.ytimg.com/vi/eKT-F52r5Wc/maxresdefault.jpg?sqp=-oaymwEmCIAKENAF8quKqQMa8AEB-AH-CYAC0AWKAgwIABABGHIgRig_MA8=&rs=AOn4CLDYAp9oIYgyOT0vvGwQUO5T5bLO7w)