Working with columns in a SELECT query

The goal of a SELECT query is to return a query result set that does the following:

At minimum, a SELECT query must specify one or more columns (or fields) to display in the query result set or to use for query criteria.

Other options for working with columns in a SELECT query include:

 

More:

Adding columns to the query

Setting the sort order

Adding criteria for the column

Adding GROUP BY and aggregate functions

Hiding a column from the query results

Setting an alias for the column

Working with columns