要求:要获取在所有行中具有唯一值的 single_address_object 示例如下数据,国家和地区在所有行中都是通用的
id , address
----------------
111 , { "City": "Garner", "Country": "US", "County": "Hancock", "Line1": "490 W 8th St", "PostalCode": "50438", "Region": "TX" }
111 , { "City": "Colleyville", "Country": "US", "County": "Tarrant", "Line1": "1002 Saddlebrook Dr", "PostalCode": "76034", "Region": "TX" }
111 , { "City": "Dublin", "Country": "US", "County": "Franklin", "Line1": "545 Metro Pl S Ste 100", "PostalCode": "43017", "Region": "TX" }
输出
需要如下新列
single_address_object
----------------------
{"Country:"US", "Region":"TX"}
检查以下内容是否适合您。如果您希望是动态的,那么您需要编写存储过程来解析列名称并使用动态列名称构建类似于下面的查询。