![]() Since a new column is created, we can reference it in the Select, Where, Group By and Order by clauses.For each Key, a new column is created when the query is run.In parentheses would be a comma separated list of the Keys we want (in this case just name) and its data type, text. ![]() In the AS clause we choose an arbitrary name, items, for our recordset structure, the storage of the Key/Values.This indicates that when any of the values for the JSON object are the null value, the null key:value. ![]() It returns a set of Key/Value pairs that we must define the storage for. That is easy to do by using the ABSENT ON NULL clause.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |