Column name alias

Is there a way to create column name alias in SELECT queries ? like (name as petName).
Was this page helpful?