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


#1

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.