MODULE 1 · Reading data
Reading · 15 min
Selecting columns
Selecting columns
A SELECT query describes the data you want to see. Start by being specific about the columns and table rather than selecting everything by habit.
Learning objectives
- Select named columns
- Read a basic table query
Choose only the fields needed for a question. Focus on explaining each decision in your own words before relying on a pattern or shortcut.
Example
SELECT name, email
FROM customers;Summary
KEY TAKEAWAYS
- SELECT chooses columns.
- A query should answer a clear question.
Reading material
Selecting columns practice prompt
Use the exercise in this lesson to check your understanding.
Previous lesson
Your progress is saved on this device. Sign in to keep it across devices.
