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.
SELECT * FROM movies ORDER BY imdb_rating DESC LIMIT 3;

Sometimes even filtered results can return thousands of rows in large databases. In these situations it becomes important to cap the number of rows in a result set.

LIMIT is a clause that lets you specify the maximum number of rows the result set will have. Here, we specify that the result set can not have more than three rows.


In this lesson we have learned how to use SQL to retrieve information from a database. We also learned how to filter queries to make the information more specific and useful. In the upcoming lessons we will learn more advanced queries.

Let's summarize what we have learned so far.

Click Next to Continue

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