Course Content
Introduction to SQL
Introduction to SQL
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?
Note
This can be achieved using different syntax in various database management systems. In our case, since we are using PostgreSQL, we should utilize the
LIMIT
clause.
In the example below, we extract the first 7 rows (in our case, the capitals of the countries) from the column.
SELECT capital FROM country LIMIT 7;
Here's a short example of the country
table:
Task
From the ' country ' table, let's retrieve 3 distinct (unique) continent
values.
Thanks for your feedback!
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?
Note
This can be achieved using different syntax in various database management systems. In our case, since we are using PostgreSQL, we should utilize the
LIMIT
clause.
In the example below, we extract the first 7 rows (in our case, the capitals of the countries) from the column.
SELECT capital FROM country LIMIT 7;
Here's a short example of the country
table:
Task
From the ' country ' table, let's retrieve 3 distinct (unique) continent
values.
Thanks for your feedback!
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?
Note
This can be achieved using different syntax in various database management systems. In our case, since we are using PostgreSQL, we should utilize the
LIMIT
clause.
In the example below, we extract the first 7 rows (in our case, the capitals of the countries) from the column.
SELECT capital FROM country LIMIT 7;
Here's a short example of the country
table:
Task
From the ' country ' table, let's retrieve 3 distinct (unique) continent
values.
Thanks for your feedback!
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?
Note
This can be achieved using different syntax in various database management systems. In our case, since we are using PostgreSQL, we should utilize the
LIMIT
clause.
In the example below, we extract the first 7 rows (in our case, the capitals of the countries) from the column.
SELECT capital FROM country LIMIT 7;
Here's a short example of the country
table:
Task
From the ' country ' table, let's retrieve 3 distinct (unique) continent
values.