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:
SELECT columns
FROM table
LIMIT number_of_rows;
In the example below, we extract the first 7 rows (in our case, the capitals of the countries) from the column:
123SELECT capital FROM country LIMIT 7;
Swipe to start coding
Write an SQL query to retrieve 3 distinct continent values from the country table.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Can you explain what happens if I use LIMIT with a number larger than the total rows?
How can I fetch a specific range of rows, not just the first few?
What happens if I omit the LIMIT clause?
Awesome!
Completion rate improved to 2.44Limiting Results
Swipe to show menu
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:
SELECT columns
FROM table
LIMIT number_of_rows;
In the example below, we extract the first 7 rows (in our case, the capitals of the countries) from the column:
123SELECT capital FROM country LIMIT 7;
Swipe to start coding
Write an SQL query to retrieve 3 distinct continent values from the country table.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
single
