clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 984328 fiddles created (11659 in the last week).

create schema Orion;
 hidden batch(es)


CREATE TABLE Nodes ( Caption varchar(12) PRIMARY KEY );
 hidden batch(es)


Insert Nodes values ('Bob');
1 rows affected
 hidden batch(es)


Insert Nodes values ('Alice');
1 rows affected
 hidden batch(es)


Insert Nodes values ('Mary');
1 rows affected
 hidden batch(es)


; WITH AllNodes ( DisplayName ) AS ( SELECT data.Caption AS DisplayName FROM Nodes AS data ) SELECT AllNodes.DisplayName FROM AllNodes;
DisplayName
Alice
Bob
Mary
 hidden batch(es)


SELECT AllNodes.DisplayName FROM ( SELECT data.Caption AS DisplayName FROM Nodes AS data ) AS AllNodes;
DisplayName
Alice
Bob
Mary
 hidden batch(es)