Limiting Results

We know that the SELECT operator can retrieve all rows from a table of all or the specific columns. However, what if we only need to fetch a specific number of rows?

We can do it using the LIMIT clause. It is always used at the end of the query. Here is the syntax for it:

In the example below, we extract the first 7 rows (in our case, the capitals of the countries) from the column:


              123
            
SELECT capital 
FROM country 
LIMIT 7;

Here's a short example of the country table:

Task

Swipe to show code editor

Write an SQL query to retrieve 3 distinct continent values from the country table.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 5

Limiting Results

We know that the SELECT operator can retrieve all rows from a table of all or the specific columns. However, what if we only need to fetch a specific number of rows?

We can do it using the LIMIT clause. It is always used at the end of the query. Here is the syntax for it:

In the example below, we extract the first 7 rows (in our case, the capitals of the countries) from the column:


              123
            
SELECT capital 
FROM country 
LIMIT 7;

Here's a short example of the country table:

Task

Swipe to show code editor

Write an SQL query to retrieve 3 distinct continent values from the country table.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 5

Switch to desktop for real-world practiceContinue from where you are using one of the options below