By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE elbat
(nmuloc varchar(8));
INSERT INTO elbat
(nmuloc)
VALUES
('x'),
('y'),
('z');
3 rows affected
SELECT coalesce(CASE
WHEN row_number() OVER (ORDER BY nmuloc DESC) <> (SELECT count(*)
FROM elbat) THEN
CASE row_number() OVER (ORDER BY nmuloc DESC)
WHEN 1 THEN
' and '
ELSE
', '
END
END,
'') + nmuloc
FROM elbat
ORDER BY row_number() OVER (ORDER BY nmuloc ASC)
FOR XML PATH('');
| XML_F52E2B61-18A1-11d1-B105-00805F49916B |
|---|
| x, y and z |