Lesson 2 of 36 minutes 48 secondsPlaceholder lesson
Your first SELECT
Pick exactly the columns you want and sort the results.
Published
In this lesson
SELECT is the question word of SQL. In this lesson you ask a table for just the columns you care about and put the answers in order.
Try it yourself
Copy this, run it, then change one thing and run it again. That is how it sticks.
SELECT title, author
FROM books
ORDER BY title;