Skip to content

Instantly share code, notes, and snippets.

@bartubozkurt

bartubozkurt/as_columns.sql

Created June 11, 2021 17:27
Show Gist options
  • Save bartubozkurt/1b18fd987e359ba231de2f0a4bcd7305 to your computer and use it in GitHub Desktop.
Save bartubozkurt/1b18fd987e359ba231de2f0a4bcd7305 to your computer and use it in GitHub Desktop.
Download ZIP
With the AS expression, we can temporarily give short names to long and difficult to use table or field names
Raw
as_columns.sql
SELECT name AS city_name FROM city;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment