When creating an alias, what's the difference between 'column AS aliasName' and 'column aliasName'?



When creating an alias, what’s the difference between ‘column AS aliasName’ and ‘column aliasName’?


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.