PQL Distinct

The PQL SELECT DISTINCT Statement
In a stable, some of the columns may contain duplicate values. This is not a problem, however, sometimes you will want to list only the different (distinct) values in a stable.

The DISTINCT keyword can be used to return only distinct (different) values.

SELECT DISTINCT Example
Now we want to select only the distinct values from the column named "City" from the stable above.

We use the following SELECT statement:

The result-set will look like this: