Four ways to name a column

Question

Accepted Answer

The AS keyword is optional when defining a column alias. Writing the alias name directly after the expression works in all major SQL databases. The = and : forms are not valid standard SQL (though = is specific to some T-SQL syntax). Using AS explicitly is recommended because it makes the alias easier to spot when reading the query.