The example uses the JSONExtract method to extract unfiltered results from a table. This example shows multiple results being returned.
The example uses the table(s) created earlier.
/* JSONExtract with several results - get the name of everyone. */ SELECT eno, edata.JSONExtract('$..firstName') FROM my_Table ORDER BY 1;
Result: The result(s) are arrays of values.
ENO edata.JSONExtract(…) -------------------------- 1 [ "Cameron" ] 2 [ "Melissa" ] 3 [ "Alex" ] 4 [ "David" ]