SQL LIMIT # of returned rows Tutorial - Interactive Database Lesson

LIMIT # of returned rows

Interactive SQL Tutorial

Often, tables contain millions of rows, and it can take a while to grab everything. If we just want to see a few examples of the data in a table, we can select the first few rows with the LIMIT keyword. If you use ORDER BY, you would get the first rows for that order.

If you wanted to see the two shortest friends_of_pickles, you would run: SELECT * FROM friends_of_pickles ORDER BY height_cm LIMIT 2;

Can you return the single row (and all columns) of the tallest friends_of_pickles?

Note:
- Some variants of SQL do not use the LIMIT keyword.
- The LIMIT keyword comes after the DESC keyword.

SQL:

SQL LIMIT # of returned rows Tutorial - Interactive Database Lesson

Lessons

LIMIT # of returned rows

Query Result:

Available Tables:

Expected Result: