Groouping

This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(86)

You rated this post out of 5. Change rating

2012-11-16 (first published: 2010-07-13)

38,121 reads

Blogs

Hello, dear blog reader. Today’s post is coming to you straight from the home...

This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...

One of the things a customer asked recently about Redgate Data Modeler was how...

Comments posted to this topic are about the item Creating a JSON Document I

Comments posted to this topic are about the item Who is Irresponsible?

Comments posted to this topic are about the item Removing TDE

I want to create a JSON document that contains data from this table:

TeamID  TeamName  City          YearEstablished
1       Cowboys   Dallas        1960
2       Eagles  Philadelphia  1933

If I run this code, what is returned?

SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;