Skip to toolbar

Forum

How to Extract data...
 
Notifications
Clear all

How to Extract data from Json data in Sql  


Steel Bird
Posts: 1
(@steelbird)
New Member
Joined: 2 weeks ago

Team,

Below is the column Data:

{"300":"0","9k":"-10","Ear":"Left","7k":"0","5k":"-10","3k":"0"}

I want the data should extract in individual columns like 500 in separate column and 0 in separate column and rest of the values fall in different columns.

Thank you,

steel.

Leave a reply

Author Name

Author Email

Title *

Maximum allowed file size is 10MB

 
Preview 0 Revisions Saved
Share: