Home > Articles

  • Print
  • + Share This
This chapter is from the book

Retrieving Multiple Columns

To retrieve multiple columns from a table, the same SELECT statement is used. The only difference is that multiple column names must be specified after the SELECT keyword, and each column must be separated by a comma.

The following SELECT statement retrieves three columns from the Products table:

Analysis ▾

Just as in the prior example, this statement uses the SELECT statement to retrieve data from the Products table. In this example, three column names are specified, each separated by a comma. The output from this statement is shown below:

  • + Share This
  • 🔖 Save To Your Account