DBAcademy

Lesson 5 of 22 · SQLite

SELECT Basics

Learn the SQL SELECT statement: pick exactly the columns you need instead of SELECT *.

The SELECT statement is the most fundamental SQL command. It retrieves data from tables.

Syntax

SELECT column1, column2 FROM table_name;
SELECT * FROM table_name;  -- All columns

Your challenge

List every person's name and street: two columns, all 20 people.

Solve it in your browser

Free, no sign-up. The SQLite database runs in your browser; your answer is checked instantly, with hints if you need them. Plus a 1-question quiz.