Choosing specific columns

Use this syntax to select only specific columns from a table, separating column names with commas:

select column_name[, column_name]... 
     from table_name

For example:

select au_lname, au_fname
from authors