The SELECT clause of a SELECT statement specifies the columns and computed columns to be included in the result table.

The sequence of the columns and computed columns in the SELECT clause specifies the sequence of the columns in the result table.

If the keyword * is included in the SELECT clause, all the columns in each of the tables and views specified in the FROM clause will be included in the result table. When the keyword * is included in the SELECT clause, column names and computed columns cannot be included in the SELECT clause.

If the keyword DISTINCT is included in the SELECT clause, only distinct rows will be included in the result table. This removes all but one row in each set of duplicate rows. If the keyword DISTINCT is not included in the SELECT clause, all rows will be included in the result table, including duplicates.