How can I query a table grouping by a unique value? I want to do something like (in relational db)
Select (field) from (table) group by (field).
To be more specific, I want to query BscTokenBalance and retrieve all registered tokens, but I want to receive only one item for each token. I tried
const query = new Moralis.Query("BscTokenBalance") query.select("symbol"); query.distinct("symbol"); const resposta = await query.find();
But they don’t group with this query. Thx in advance!