GitHub

json-array-transact-sql.md

JSON_ARRAY constructs JSON array text from zero or more expressions. The JSON_ARRAY function uses the rules described in this FOR JSON article to convert SQL data types to JSON types in the JSON array ...
GitHub

SQL Server does not support array_agg

Move GROUP_BY from SQL to clojure group-by Move to-many into VendorAdapters, use array_agg for adapters which support it and a. use string_agg in SQL and str/split in Clojure and use attributes to ...
Ars Technica

Finding Median Value From an array. In PHP. (Why doesn't SQL Server have a median function?)

//Need to get the mid point of array. Use Floor because we always want to round down. $mid = floor($count/2); //If there are an even amount of elements... if (($count ...