Fetch the first data from multiple data available in a column

Moralis General
#1

Hi,
If I have a column with the following data
Column name
Green
Green
Blue
Green
Yellow
Yellow
Orange
Pink

My question is this, how can I fetch out the data such that it will return only one of each the data

Like the result should be
Green
Blue
Yellow
Orange
Pink

Thanks.

#2

Like you want only the unique/distinct values form that column?

#3

I want only one of the data returned and not two I.e I don’t want any duplicate of any of the data
Thanks

#4

One way would be to get all the values and then to identify the unique values.

You can also search on google if there is a solution for how to do it with parse server as parse server is used in a Moralis server.