Selecting specific columns

Learn to fetch only the columns you want, separated by commas.

Selecting specific columns

Most queries need only a few columns. You list them after SELECT, separated by commas.

SELECT name, email, city
FROM customers;

This fetches three columns: name, email and city. Fewer columns mean a faster query and less network load.

name, email, city is selected from customers.

Selecting specific columns — details

The column order in your query sets the order in the result. If you write SELECT name, price then name comes first, then price. You can pick any order; it does not have to match the table. This flexibility lets you arrange reports in a readable order. For example you can put price first, then name; it makes more sense for the reader.

Exercise Selecting specific columns

Select the name, email and city columns from customers.

Show example solution

SELECT name, email, city
FROM customers

Test yourself

Selecting specific columns: match the terms

SELECT

choose columns
FROM

table name
comma

separate columns
;

end query

Separate columns with comma

SELECT name,____
FROM customers;

Show answer

SELECT name, email
FROM customers;

What separates two columns?
- A period
- A colon
- A comma
- A dash
Show answer

A comma — Columns are separated by commas.

Next lesson: Column aliases with AS

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies