DocumentDB SQL - 在关键字中

DocumentDB SQL In Keyword - 从Overview，Select Clause，From Clause，Where Clause，Operators，Keywords，In Keyword，Value Keyword，Order By Clause，Iteration，Joins，Aliasing，Array Creation，简单而简单的步骤学习DocumentDB SQL标量表达式，参数化SQL，内置函数，Linq到SQL转换，JavaScript集成，用户定义函数，复合SQL查询。

IN关键字可用于检查指定的值是否与列表中的任何值匹配. IN运算符允许您在WHERE子句中指定多个值. IN相当于链接多个OR子句.

类似的三个文档被认为是在前面的例子中完成的.以下是 AndersenFamily 文件.

{    "id": "AndersenFamily",    "lastName": "Andersen",   "parents": [       { "firstName": "Thomas", "relationship":  "father" },       { "firstName": "Mary Kay", "relationship":  "mother" }    ],    "children": [       {          "firstName": "Henriette Thaulow",          "gender": "female",          "grade": 5,          "pets": [ { "givenName": "Fluffy", "type":  "Rabbit" } ]       }    ],    "location": { "state": "WA", "county": "King", "city": "Seattle" },    "isRegistered": true }

以下是 SmithFamily 文件.

{    "id": "SmithFamily",    "parents": [       { "familyName": "Smith", "givenName": "James" },       { "familyName": "Curtis", "givenName": "Helen" }    ],   "children": [       {         "givenName": "Michelle",          "gender": "female",          "grade": 1       },      {          "givenName": "John",          "gender": "male",          "grade": 7,         "pets": [             { "givenName": "Tweetie", "type": "Bird" }          ]       }    ],      "location": {       "state": "NY",       "county": "Queens",       "city": "Forest Hills"    },   "isRegistered": true }

以下是 WakefieldFamily 文件.

{    "id": "WakefieldFamily",    "parents": [       { "familyName": "Wakefield", "givenName": "Robin" },       { "familyName": "Miller", "givenName": "Ben" }    ],      "children": [       {          "familyName": "Merriam",          "givenName": "Jesse",          "gender": "female",          "grade": 6,          "pets": [             { "givenName": "Charlie Brown", "type": "Dog" },             { "givenName": "Tiger", "type": "Cat" },            { "givenName": "Princess", "type": "Cat" }          ]       },       {          "familyName": "Miller",          "givenName": "Lisa",          "gender": "female",          "grade": 3,         "pets": [             { "givenName": "Jake", "type": "Snake" }          ]       }    ],      "location": { "state": "NY", "county": "Manhattan", "city": "NY" },    "isRegistered": false }

让我们来看一个简单的例子.

In Key<a href= Word"/>

以下是将检索数据的查询其姓氏是"史密斯"或韦克菲尔德.

SELECT * FROM Families.parents[0] f WHERE f.familyName IN ('Smith', 'Wakefield')

执行上述查询时，会产生以下输出.

[    {       "familyName": "Wakefield",       "givenName": "Robin"    },    {       "familyName": "Smith",       "givenName": "James"    } ]

让我们考虑另一个简单的例子，其中将检索所有家庭文件，其中id是"SmithFamily"或"AndersenFamily"之一.以下是查询.

SELECT * FROM Families  WHERE Families.id IN ('SmithFamily', 'AndersenFamily')

执行上述查询时，它会产生以下输出.

[    {       "id": "SmithFamily",       "parents": [          {             "familyName": "Smith",             "givenName": "James"          },          {             "familyName": "Curtis",             "givenName": "Helen"         }       ],         "children": [          {             "givenName": "Michelle",             "gender": "female",             "grade": 1          },         {             "givenName": "John",             "gender": "male",             "grade": 7,            "pets": [                {                   "givenName": "Tweetie",                   "type": "Bird"                }              ]          }       ],         "location": {          "state": "NY",          "county": "Queens",          "city": "Forest Hills"       },        "isRegistered": true,       "_rid": "Ic8LAJFujgEDAAAAAAAAAA==",       "_ts": 1450541623,       "_self": "dbs/Ic8LAA==/colls/Ic8LAJFujgE=/docs/Ic8LAJFujgEDAAAAAAAAAA==/",       "_etag": "00000600-0000-0000-0000-567582370000",       "_attachments": "attachments/"    },   {       "id": "AndersenFamily",       "lastName": "Andersen",       "parents": [          {             "firstName": "Thomas",             "relationship": "father"         },         {             "firstName": "Mary Kay",             "relationship": "mother"          }       ],        "children": [          {             "firstName": "Henriette Thaulow",             "gender": "female",             "grade": 5,            "pets": [                {                   "givenName": "Fluffy",                   "type": "Rabbit"                }             ]          }       ],        "location": {               "state": "WA",          "county": "King",          "city": "Seattle"          },        "isRegistered": true,       "_rid": "Ic8LAJFujgEEAAAAAAAAAA==",       "_ts": 1450541624,       "_self": "dbs/Ic8LAA==/colls/Ic8LAJFujgE=/docs/Ic8LAJFujgEEAAAAAAAAAA==/",       "_etag": "00000700-0000-0000-0000-567582380000",       "_attachments": "attachments/"    }]