SQL

sql alias

-- SELECT my_col_name AS my_alias FROM my_table;
SELECT sysdate() AS "Current date";   			-- MySQl Alias
SELECT sysdate AS "Current date" FROM dual;   	-- same in Oracle

SQL SELECT AS Alias

SELECT first_name AS name
FROM Customers;

Aliasing in SQL

-- Aliasing simply means you assign a temporary name to something.
-- For example:
SELECT MAX(budget) AS max_budget,
       MAX(duration) AS max_duration
FROM films;