Следната отделна заявка вече работи:
SELECT DISTINCT c.name FROM c
но заявката по-долу не работи, има ли нещо нередно тук?
SELECT COUNT(DISTINCT c.name) FROM c
Failed to query documents for collection products: {"code":400,"body":"{\"code\":\"BadRequest\",\"message\":\"Message: {\\\"errors\\\":[{\\\"severity\\\":\\\"Error\\\",\\\"location\\\":{\\\"start\\\":13,\\\"end\\\":21},\\\"code\\\":\\\"SC1001\\\",\\\"message\\\":\\\"Syntax error, incorrect syntax near 'DISTINCT'.\\\"}]}\\r\\nActivityId: 05bf1757-ce1b-4ee4-9ae5-f2b778c55ded, Microsoft.Azure.Documents.Common/2.0.0.0\"}","activityId":"05bf1757-ce1b-4ee4-9ae5-f2b778c55ded"}
SELECT VALUE COUNT(1) from (SELECT DISTINCT c.name from c)
- person Antony   schedule 26.08.2019