15.10 - Example: JSONExtractValue with Filtered Results - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K

This example shows how to use the JSONExtractValue method to filter results. This query gets the name of all persons older than 23.

JSONExtractLargeValue can be substituted for JSONExtractValue.
SELECT eno, edata.JSONExtractValue('$.[?(@.age > 23)].firstName') 
FROM my_table 
ORDER BY 1;
Result:
ENO edata.JSONExtractValue(…)
-----------------------------
1   Cameron	
2   ?          
3   Alex
4   David