-- 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
-- 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;