Example: JSONExtract with Filtered Results - Teradata Vantage

The example uses the JSONExtract method to extract filtered results from a table.

/* JSONExtract with filtered results - get the name of everyone older than 23. */ 

SELECT eno, edata.JSONExtract('$.[?(@.age > 23)].firstName') 
FROM my_table 
ORDER BY 1;

Result:

ENO edata.JSONExtract(…)
---------------------------
1  [ "Cameron" ]
2  ?
3  [ "Alex" ]
4  [ "David" ]