By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT
(JSON_VALUE(cast(ad.data_map as varchar(max)),'$.dataMap."1754".value')) CorrespondanceNumber,
(JSON_VALUE(cast(ad.data_map as varchar(max)),'$.dataMap.***"1754"***.value')) Agency,
(JSON_VALUE(cast(ad.data_map as varchar(max)),'$.dataMap."1754".value')) Protocal
FROM actions_new a
LEFT JOIN action_data ad on ad.id_ref = a.id
WHERE baid = 32 and displayrequestid < 100;
CorrespondanceNumber | Agency | Protocal |
---|