/* Available in MySQL and SQL Azure */
SELECT
CountryCode,
JSON_ARRAYAGG(Name),
JSON_OBJECTAGG(Name, Population)
FROM city
GROUP BY CountryCode
| CountryCode |
JSON_ARRAYAGG(Name) |
JSON_OBJECTAGG(Name, Population) |
| ABW |
["Oranjestad"] |
{"Oranjestad":29,034} |
| AFG |
["Kabul","Mazar-e-Sharif","Herat","Qandahar"] |
{"Kabul":1,780,000, "Mazar-e-Sharif":127,800, "Herat":186,800, "Qandahar":237,500} |
| AGO |
["Namibe","Benguela","Lobito","Luanda","Huambo"] |
{"Namibe":118,200, "Benguela":128,300, "Lobito":130,000, "Luanda":2,022,000, "Huambo":163,100} |
| AIA |
["South Hill","The Valley"] |
{"South Hill":961, "The Valley":595} |
| ALB |
["Tirana"] |
{"Tirana":270,000} |
| AND |
["Andorra la Vella"] |
{"Andorra la Vella":21,189} |
| ANT |
["Willemstad"] |
{"Willemstad":2345} |
| ARE |
["Ajman","Sharja","Abu Dhabi","al-Ayn","Dubai"] |
{"Ajman":114,395, "Sharja":320,095, "Abu Dhabi":398,695, "al-Ayn":225,970, "Dubai":669,181} |
| ... |
| JSON_ARRAYAGG - 把结果集作为一个 JSON 数组返回。
JSON_OBJECTAGG - 把结果集作为一个 JSON 对象返回。 |