Aliasing
Default column names in an SQL result set come from the fields used to create them. You can use aliasing to rename these columns. This is helpful for making it clear what the column is about.
Deze oefening maakt deel uit van de cursus
Introduction to SQL
Oefeninstructies
- Add an alias to the SQL query to rename the
authorcolumn tounique_authorin the result set.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Alias author so that it becomes unique_author
SELECT DISTINCT author ___
FROM books;