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