A JSON column contains {"customer":{"name":"Ava"}}. A query needs the scalar name value. Which function should be evaluated?

Published
  1. JSON_QUERY as the scalar-name equivalent
  2. COUNT without reading the JSON property
  3. CHECKPOINT
  4. JSON_VALUE with the appropriate path

Comments — 0