SQL Aliases

SQL aliases are used to temporarily rename a table or a column heading.

-----------------------------------------------

SQL Alias Syntax for Columns

 SELECT column_name AS alias_name

 FROM table_name;

------------------------------------------------

SQL Alias Syntax for Tables

 SELECT column_name(s)

 FROM table_name AS alias_name;

------------------------------------------------

Display a column in uppercase

SELECT 

  UPPER(firstname),

  lastname

FROM Students   

LIMIT 10