Example: JSONExtract with Filtered Results

Teradata Vantage™ JSON Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K
The example uses the JSONExtract method to extract filtered results from a table.
The example uses the table(s) created earlier.
/* 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" ]