你即將離開本站

並前往https://www.py4u.net/discuss/1505601

How to return distinct values in a JSON_ARRAYAGG - py4u

SELECT JSON_OBJECT( 'ArrayKey' VALUE JSON_ARRAYAGG( col ) ) AS jsonResult FROM(SELECT DISTINCT column_name AS col FROM tbl_name);.

確定！ 回上一頁

查詢 「JSON_ARRAYAGG」的人也找了：

  1. JSON_ARRAYAGG
    2.
  2. json_arrayagg sql server
    3.
  3. oracle json_arrayagg
    4.
  4. json_arrayagg does not exist
    5.
  5. json_arrayagg mysql version
    6.
  6. json_arrayagg( json_object)
    7.
  7. json_arrayagg order by
    8.
  8. json_arrayagg alternative
    9.