changing column names in sql query results

1--The following example renames the column TerritoryID in the table Sales.SalesTerritory to TerrID in the AdventureWorks database.
2
3EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';

1ALTER TABLE "table_name" RENAME COLUMN "column 1" TO "column 2";

1ALTER TABLE table_name
2CHANGE COLUMN old_name TO new_name;
3

1SELECT NAME AS "Employee Name" FROM PEOPLE;
2
3SELECT p.NAME AS "Employee Name", s.SALARY AS "Employee Salary"
4FROM PEOPLE p
5JOIN SALARIES s ON p.ID = s.ID;

1MySQL:
2ALTER TABLE Customer CHANGE Address Addr char(50);
3
4Oracle:
5ALTER TABLE Customer RENAME COLUMN Address TO Addr;

1SELECT data.column AS `Label`