Log in to test your SQL Server knowledge with daily questions.
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Telp/WA.0821°3111°179 Ruko Pd. Lestari, Jl. Raden Patah No.Raya Blok C/7-8, RT.001/RW.012, Karang Tim., Kec....
Telp/WA.0821°3111°179 Lippo Karawaci, 105, Jl. Boulevard Diponegoro No.1200 FF #A 3A, Bencongan, Kecamatan Kelapa...
Telp/WA.0821°3111°179 Jl. Gatot Subroto KM 3 RT 003 RW 009 Kec. Cibodas, Kota Tan...
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 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers