Question : can i use alias in where clause
Answered by : defiant-dingo-0xsjqvfmpkls
column_alias can be used in an ORDER BY clause, but it cannot be used in a WHERE, GROUP BY, or HAVING clause. Standard SQL disallows references to column aliases in a WHERE clause. This restriction is imposed because when the WHERE clause is evaluated, the column value may not yet have been determined.Source : | Last Update : Sun, 24 Oct 21