SELECT: Choosing Columns

Instead of *, list the columns you want, separated by commas. The results come back in that order.

Examplesql

Look at the other tables too. Change the query to read products and pick name and price.

Examplesql

When a script has several statements, you get a result table for each one.

Quick check

Which query returns only the names of customers?

SELECT * FROM customers;SELECT name FROM customers;GET name FROM customers;

Your turn: write the code

Select the name and city of every customer.

Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.

Tip: use the left and right arrow keys to move between lessons.