What are the two ways to specify a column alias?

Answer 1

1.Naming the alias after the column specification separated by a space .
Ex: Select empid id, fname first from employee
2. Use of an 'AS' word to specify the alais more clearly
Ex: Select empid as id, fname as first from employee