Choosing Specific Columns
To select specific columns in a table, explicitly list each column in the select list. For example, to list only the employee first names and their telephone numbers, use:
SELECT c.FirstName, c.Phone
FROM AdventureWorks.HumanResources.Employee e
JOIN AdventureWorks.Person.Contact c
ON e.ContactID = c.ContactID
ORDER BY FirstName ASC
Specifying the columns in the select list can also include specifying an alias (for example, proj_sales AS "Projected Sales") or other expressions, such as (price = price * 1.15, or SUM(SalesAmount).