PosgtreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, Postgres is able to run on various platforms, such as macOS, Solaris, Windows, Unix, and Linux. PostgreSQL databases provide enterprise-class database solutions and are used by a wide […]
2020-05-11
9,818 reads
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Comments posted to this topic are about the item Creating a JSON Document II
Hi, I'm currently trying to implement policy based mgmt with a condition to query...
We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers