sql as
snippet in sql

sql as


Renames a table or column with an alias value which only exists for the
duration of the query.
Example: Aliases north_east_user_subscriptions column
SELECT north_east_user_subscriptions AS ne_subs
FROM users
WHERE ne_subs > 5;

sql as


SELECT CustomerID AS ID, CustomerName AS Customer

sql as


-- AS is a keyword that allows you to rename a column or table using an alias
SELECT column_name AS 'Alias'
FROM table_name;