Log in to test your SQL Server knowledge with daily questions.
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
BCA KCU SUNTER Hub.0853•5504•2311 Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18,...
Wisma 46, Jl. Jenderal Sudirman No.5 Lantai Dasar, RT.5/RW.3, Senayan, Kec. Kby. Baru, Kota...
Rukan Multi Guna Kemayoran, Jl. Rajawali Selatan Raya Blok C5 No. 2, Blok 2,...
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