Learn
We’ve been working with a fairly small table (fewer than 250 rows), but most SQL tables contain hundreds of thousands of records. In those situations, it becomes important to cap the number of rows in the result.
For instance, imagine that we just want to see a few examples of records.
SELECT * FROM movies LIMIT 10;
LIMIT
is a clause that lets you specify the maximum number of rows the result set will have. This saves space on our screen and makes our queries run faster.
Here, we specify that the result set can’t have more than 10 rows.
LIMIT
always goes at the very end of the query. Also, it is not supported in all SQL databases.
Instructions
1.
Combining your knowledge of LIMIT
and ORDER BY
, write a query that returns the top 3 highest rated movies.
Select all the columns.
Take this course for free
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.