distinct
Returns distinct set of records
Works with the following datatypes:
This function works with 2.1 endpoint(s). What does this mean? »
The distinct
keyword can be used in conjunction with $select
to return one record for each distinct value in the selected column(s). For example, to fetch the distinct departments
https://data.cityofchicago.org/resource/tt4n-kn4t.json?$select=distinct department
It can also be used in a full $query
to select distinct values.
https://data.cityofchicago.org/resource/tt4n-kn4t.json?$query=select distinct department