Question: how to change column name in select query?
Answer: SELECT FirstName AS First , LastName AS Last FROM Person.Person; ...  — Try rewriting our first example without using AS. ...  SELECT UPPER(LastName) as [LAST NAME] FROM Person.Person. ...  -- Answer SELECT DISTINCT UPPER(FirstName) AS [Distinct Names] FROM Person.Person;