Example: JSONExtractValue with Filtered Results - Advanced SQL Engine - Teradata Database

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

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

ENO edata.JSONExtractValue(…)
-----------------------------
1   Cameron	
2   ?          
3   Alex
4   David