Help With SQL

A discussion about a forum post for handling a running subtraction in a SQL query.
For my first forum fun post,...

2011-05-21

672 reads

Answering SQL Questions and Forum Fun Overview

Why SQL questions are interesting and how I'm using forums to challenge myself and help others.
I like a good SQL...

2011-05-19

649 reads

A discussion of where logic should go and why SQL might be the best place.
SQL is a powerful language and...

2011-05-18

840 reads

Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...

Why this comparison feels confusing If you’re a Power BI report author who’s just...

I’m not sure I knew identity column values could not be updated. I ran...

I have mentioned this several times over several years. Can someone please help me...

SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...

Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...

In a SQL Server 2025 table, called Beer, I have this data:

BeerIDBeerName
1Becks
2Fat Tire
3Mac n Jacks
4Alaskan Amber
8Kirin

I run this code:

SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;

What are the results?