sql rename column in select

1EXEC SP_RENAME 'TABLE_NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME'

1-- Oracle, MySQL 8+
2ALTER TABLE table_name RENAME COLUMN current_name TO new_name;
3-- MySQL < 8:
4ALTER TABLE table_name CHANGE current_name new_name datatype(length);
5-- SQL Server:
6EXEC SP_RENAME 'table_name.current_name' , 'new_name', 'COLUMN'

1ALTER TABLE table_name RENAME COLUMN old_name TO new_name;

1EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';
2

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;

1SELECT data.column AS `Label`