select as code example

Example 1: 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;

Example 2: SELECT INTO

SELECT * INTO nome_da_tabela_que_estao_a_mexer_BKP
	FROM nome_da_tabela_que_estao_a_mexer

Example 3: sql as

SELECT CustomerID AS ID, CustomerName AS Customer

Example 4: 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;