Choose the Columns · StackMonsters

SELECT * returns every column. Most of the time you need only some of them.

List the columns

Write the column names after SELECT, with a comma between each two:

sql

SELECT name, country FROM customers;

SELECT name, countryreturn these columnsFROM customersfrom this table;end

The parts of the query

customers

id	name	email	country	city
1	Ava Chen	ava.chen@example.com	CA	Toronto
2	Liam Patel	liam.p@example.com	CA	Peterborough
3	Sofia Rossi	sofia.rossi@example.com	IT	Milan

SELECT name, country keeps two columns and every row

The result has the columns in the order you list them. SELECT country, name puts country first.

* means "every column, in the table's order".

SELECT and FROM are keywords. Upper case or lower case both work. This course writes keywords in upper case so they stand out.
Spaces and new lines between words do not matter. A long query can use one line per part:

sql

SELECT name,
       email
FROM customers;

The ; marks the end of a statement. You need it between two queries in the same run. With one query, it is optional.