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

CREATE TABLE x SELECT 'aaa' a, 999 b UNION ALL SELECT 'bbb', 888 UNION ALL SELECT 'ccc', 777;
 hidden batch(es)


select * from x;
a b
aaa 999
bbb 888
ccc 777
 hidden batch(es)


select * from x order by a<b; select * from x order by a=b; select * from x order by a<>b; select * from x order by a<>b,b;
a b
aaa 999
bbb 888
ccc 777
a b
aaa 999
bbb 888
ccc 777
a b
aaa 999
bbb 888
ccc 777
a b
ccc 777
bbb 888
aaa 999
 hidden batch(es)