Question
When creating an alias, what’s the difference between ‘column AS aliasName’ and ‘column aliasName’?
Answer
There is no difference between those two statements, having the AS keyword is totally optional. Using AS is just a more explicit way of mentioning an alias.