Lesson 2 of 30
More than one column
Today at the studio
Nagi is happy with your first lists, but a list of titles alone is not much of a briefing. "Can I see a bit more next to each one?" he asks, while Byte walks over a stack of papers.
The idea
List several columns after SELECT, separated by commas. The result shows them in the order you wrote them, so the order is your choice.
A star, *, means every column of the table. It is perfect for a first look at an unknown table, but naming the columns you need is clearer and keeps results small.
Example
SELECT name, voice_actor FROM characters
Your turn
0 of 4 questions
Question 1 of 4
Show the title and genre of every show.