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. 1130703 fiddles created (16569 in the last week).

create table it200117a ( id smallint generated always as identity , prdct_nme text not null ); insert into it200117a (prdct_nme) values ('三角鉛筆'),('藍桿鉛筆'),('黃桿鉛筆'),('學習鉛筆'),('代針筆');
5 rows affected
 hidden batch(es)


select a.prdct_nme as prdct_nme1 , b.prdct_nme as prdct_nme2 from it200117a a cross join it200117a b where a.id <> b.id and a.id < b.id
prdct_nme1 prdct_nme2
三角鉛筆 藍桿鉛筆
三角鉛筆 黃桿鉛筆
三角鉛筆 學習鉛筆
三角鉛筆 代針筆
藍桿鉛筆 黃桿鉛筆
藍桿鉛筆 學習鉛筆
藍桿鉛筆 代針筆
黃桿鉛筆 學習鉛筆
黃桿鉛筆 代針筆
學習鉛筆 代針筆
 hidden batch(es)