clear markdown compare help best fiddles feedback dbanow.uk
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. 2591652 fiddles created (45709 in the last week).

create table test (Id char);
 hidden batch(es)


insert into test values('A');
1 rows affected
 hidden batch(es)


insert into test values('B');
1 rows affected
 hidden batch(es)


insert into test values('C');
1 rows affected
 hidden batch(es)


insert into test values('D');
1 rows affected
 hidden batch(es)


insert into test values('E');
1 rows affected
 hidden batch(es)


select a.id, b.id from test a cross join test b where a.id<>b.id;
ID ID
A B
A C
A D
A E
B A
B C
B D
B E
C A
C B
C D
C E
D A
D B
D C
D E
E A
E B
E C
E D
 hidden batch(es)