sql as
snippet in sql

sql as

user9336

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

user1772

SELECT CustomerID AS ID, CustomerName AS Customer

sql as

user2729

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