Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Limiting Results | Retrieving Data
Introduction to SQL
course content

Course Content

Introduction to SQL

Introduction to SQL

1. Retrieving Data
2. Sorting Retrieved Data
3. Filtering Data
4. Advanced Data Filtering
5. Aggregate Functions

bookLimiting 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.

1
SELECT capital FROM country LIMIT 7;
copy

Here's a short example of the country table:

Task

From the ' country ' table, let's retrieve 3 distinct (unique) continent values.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 1. Chapter 5
toggle bottom row

bookLimiting 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.

1
SELECT capital FROM country LIMIT 7;
copy

Here's a short example of the country table:

Task

From the ' country ' table, let's retrieve 3 distinct (unique) continent values.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 1. Chapter 5
toggle bottom row

bookLimiting 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.

1
SELECT capital FROM country LIMIT 7;
copy

Here's a short example of the country table:

Task

From the ' country ' table, let's retrieve 3 distinct (unique) continent values.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

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.

1
SELECT capital FROM country LIMIT 7;
copy

Here's a short example of the country table:

Task

From the ' country ' table, let's retrieve 3 distinct (unique) continent values.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Section 1. Chapter 5
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
some-alt