Issue with Json_extract in SQL

Asked by At

Hi I am using this SQL code to fetch data, its running properly. But Actually there is one issue I have data in metadata under displayValues--> Name:

meta_data-->displayValues-->Name

which i want to pick, I am using
JSON_EXTRACT(meta_data,'$.\"displayValues\"')NAME

which is giving me

{"displayValues":{"Connection No":"121","Meter No":"L1","Name":"Mr ABC","House No":"e11","Address":"CROSSING,India"},}

But i just need Name:

How to do that? please help.

0 Answers