How to pick JSON array from a column in Sql in the below example

Question

How to pick json object from below json array in sql. Example

[{“name”:”juhi”, “roll”: “1”, “subject”:”maths”},{“name”:”shubham”, “roll”: “2”, “subject”:”Physics”}] 

How can I pick these json objects separately through a sql query. Result I want :

{“name”:”juhi”, “roll”: “1”, “subject”:”maths”}

I had tried json_query & json_value but nothing works for me.