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.