我试图从数组json获取电子邮件,但它返回空值
[ { "name": "Arun", "email": "arun@arun.com" }, { "name": "Arun kumar", "email": "arunkumar@gmail.com" } ]
我的json查询是 select json->>"$.name" as email from json
select json->>"$.name" as email from json
但此查询返回空值
