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?

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.

Task

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

Here's a short example of the country table:

idnamecontinentregionsurfaceareacapitalpopulation
1JapanAsiaEastern Asia377829Tokyo126714000
2LatviaEuropeNULL64589Riga2424200
3MexicoNorth AmericaCentral America1958201Mexico City98881000
.....................
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 1. Chapter 5
toggle bottom row