I'm running a query on a GeoServer WFS layer, using a CQL_FILTER. This results in duplicates, whereas I only want to see one instance of each matching result.
The query I'm running is:
which returns multiple instances of "CITY MOTORS":
Is it possible to use a SELECT DISTINCT statement in the CQL_FILTER, so that only one instance of "CITY MOTORS" is returned?
For example, in PGAdmin this query returns the results I need: