Cosmos db支持子查询和DISTINCT关键字.所以，这样的事情应该起作用

Cosmos db supports subqueries and DISTINCT keyword. So, something like this should work

  SELECT n2
    FROM c
    JOIN (SELECT DISTINCT value s.name FROM s IN c['stuff'])  n2

第一项结果

[
    {
        "n2": "A"
    },
    {
        "n2": "B"
    },
    {
        "n2": "C"
    }
]

参考: https://docs.microsoft.com/zh- gb/azure/cosmos-db/sql-query-subquery

P.S.此外，Cosmos db现在支持分组依据 https://docs.microsoft.com/zh-CN/azure/cosmos-db/sql-query-group-by

P.S. Also, Cosmos db now supports Group By https://docs.microsoft.com/en-gb/azure/cosmos-db/sql-query-group-by