给出一个来自Microsoft示例的示例文档,如下所示:
{
"id": "AndersenFamily",
"lastName": "Andersen",
"parents": [
{ "firstName": "Thomas" },
{ "firstName": "Mary Kay"}
],
"children": [
{
"firstName": "Henriette Thaulow",
"gender": "female",
"grade": 5,
"pets": [{ "givenName": "Fluffy" }]
}
],
"address": { "state": "WA", "county": "King", "city": "seattle" },
"creationDate": 1431620472,
"isRegistered": true
}我们可以看到,有一个包含文档数组的子集children。
假设我想要使用SELECT ... FROM ... WHERE ...类型语法编写一个查询,我该如何编写一个查询来查找有任何女儿(任何性别为“女性”的孩子)的家庭?
所以就像这样
SELECT c.id
FROM c
WHERE c.children.contains( // I'm stuck!我想知道我是否遗漏了一个JOIN或什么,但老实说,我不确定我从这里到哪里,我正在努力在谷歌中找到任何有帮助的部分,因为我不确定如何表达我的搜索!
发布于 2017-03-04 05:14:02
您需要JOIN关键字来解开子对象,然后对性别应用过滤器,如下所示:
SELECT f.id
FROM family f
JOIN child IN f.children
WHERE child.gender = "female"https://stackoverflow.com/questions/42588163
复制相似问题