Limiting ResultsLimiting Results

We know that the SELECT operator can retrieve all rows from a table or 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