Click here to navigate the course.

Drag the edges to resize the window.

In Projects, you can keep track of your progress as you go throught the tasks. Check each item as you complete it!

Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Learn
Queries

Select

Previously, we learned that SELECT is used every time you want to query data from a database.

Suppose we are only interested in two of the columns. We can select individual columns by their names (separated by a comma):

SELECT column1, column2 FROM table_name;

To make it easier to read, we moved FROM to another line.

Line breaks don't mean anything specific in SQL. We could write this entire query in one line, and it would run just fine.

Report a Bug
If you see a bug or any other issue with this page, please report it here.