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

Course Content

Introduction to SQL

Limiting ResultsLimiting 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?


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.


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

Here's a short example of the country table:

1JapanAsiaEastern Asia377829Tokyo126714000
3MexicoNorth AmericaCentral America1958201Mexico City98881000
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 1. Chapter 5
toggle bottom row