Chapter 2: Queries: Selecting Data from a Table

Choosing specific columns

To select only specific columns in a table, use:

select column_name[, column_name]... 
     from table_name

Separate column names with commas, for example:

select au_lname, au_fname
from authors