The example uses the JSONExtract method to extract NULL results from a table.
The example uses the table(s) created earlier.
/* JSONExtract with some NULL results – get everyone's job. */ SELECT eno, edata.JSONExtract('$..job') FROM my_table ORDER BY 1;
Result: A NULL is returned for a person in the table who does not have a job.
ENO edata.JSONExtract(…) -------------------------- 1 [ "programmer" ] 2 ? 3 [ "CPA" ] 4 [ "small business owner" ]