Choose Specific Columns

You can select specific columns in a table by separating column names with commas.

To select only specific columns in a table, use:

select column_name[, column_name]... 
     from table_name

For example:

select au_lname, au_fname
from authors