Sjors Takes

All authors

All authors

Blogs

SSMS Evaluation – future ready

By

In previous posts, we looked at the SQL Server engine. for us DBAs, the...

Claude.ai vs Claude API

By

You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...

T-SQL Tuesday #198–Change Detection

By

This month we have a new host, Meagan Longoria, who graciously agreed to help...

Read the latest Blogs

Forums

Alamat kontak resmi BCA KCP Industri Telp:0817866887

By Layanan.bca

WhatsApp:0817866887 Jl. Industri II No.14, Muktiharjo Lor, Kec. Genuk, Kota Semarang, Jawa Tengah 50197

Alamat kontak resmi BCA KCU SEMARANG Telp:0817866887

By Halo_BCA

WhatsApp:0817866887 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133

Alamat kontak resmi BCA KCP Riau Telp:0817866887

By Layanan_BCA_24jam

WhatsApp:0817866887 Jl. Laks Jl. L. L. R.E. Martadinata No.92, Cihapit, Kec. Bandung Wetan, Kota...

Visit the forum

Question of the Day

Creating a JSON Document IV

I have this data in a table called dbo.NFLTeams 

TeamID  TeamName       City             YearEstablished
------  --------       ----             ---------------
1       Cowboys        Dallas           1960
2       Eagles         Philadelphia     1933
3       Packers        Green Bay        1919
4       Chiefs         Kansas City      1960
5       49ers          San Francisco    1946
6       Broncos        Denver           1960
7       Seahawks       Seattle          1976
8       Patriots       New England      1960
If I run this code, how many rows are returned? 
SELECT 
  YearEstablished,
  json_objectagg(city : TeamName)
FROM dbo.NFLTeams
GROUP BY  YearEstablished;

See possible answers