SELECT chooses which columns you see
SELECT names the columns you want back, and FROM names the table they come from. Any column you don't list is simply left out of the result. Think of a table like a spreadsheet: each row is one item, each column is one fact about it — SELECT picks which facts you see.
A tiny example
In plain English: Show me the name and category of every menu item.
SELECT name, category
FROM menu_items;Query result
| name | category |
|---|---|
| Honey latte | drink |
| Blueberry scone | pastry |
| House blend | coffee |
The menu_items table has more columns, but only name and category appear in your results because those are the two SELECT named.
Related SQL lessons
Practice SELECT step by step
The Foundations Track has beginner puzzles built around this idea. Tap tiles, see real results. No terminal, no setup.
practice this in the courseReady for a break?
A fresh, bite-sized SQL puzzle waits every morning. Tap tiles, see real results. No terminal, no setup, no timers.
Try today's free SQL puzzle