By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Person (
FirstName VARCHAR(100),
LastName VARCHAR(100)
)
INSERT Person
VALUES
('Joe', 'Bloggs'),
('Anne', 'Bloggs'),
('Mary', 'Smith'),
('Larry', 'Stooge'),
('Curly', 'Stooge'),
('Moe', 'Stooge')
6 rows affected
SELECT
P.LastName + ', '
+ STRING_AGG(P.FirstName, ' ') WITHIN GROUP(ORDER BY P.FirstName)
AS People
FROM Person P
GROUP BY P.LastName
--HAVING COUNT(*) >= 2
ORDER BY P.LastName
| People |
|---|
| Bloggs, Anne Joe |
| Smith, Mary |
| Stooge, Curly Larry Moe |