Aliases let us temporarily rename columns.
When to use
Use them whenever you want to rename a column temporarily for any given set of results.
SELECT [First Name] AS "Customer First Name"
This will give an alias of 'Customer First Name' to the column 'First Name'. This might be useful to differentiate between another column you have chosen to display, 'Potential Customer First Name' for example.
Hints & tips
- Aliases are good for temporarily renaming columns
- They aren't really renamed, just labeled differently in your results
Lesson notes are only available for subscribers.