By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t(n1 varchar(50), n2 varchar(50));
insert into t select 'alice','elizabeth';
insert into t select 'chris','john';
insert into t select 'chris','mike';
insert into t select 'elizabeth','jack';
insert into t select 'jack','elizabeth';
insert into t select 'joe','mike';
insert into t select 'john','chris';
insert into t select 'mike','joe';
Records: 1 Duplicates: 0 Warnings: 0
Records: 1 Duplicates: 0 Warnings: 0
Records: 1 Duplicates: 0 Warnings: 0
Records: 1 Duplicates: 0 Warnings: 0
Records: 1 Duplicates: 0 Warnings: 0
Records: 1 Duplicates: 0 Warnings: 0
Records: 1 Duplicates: 0 Warnings: 0
Records: 1 Duplicates: 0 Warnings: 0
select * from t
where n1 < n2;
| n1 | n2 |
|---|---|
| alice | elizabeth |
| chris | john |
| chris | mike |
| elizabeth | jack |
| joe | mike |
select * from t
where not(n1 < n2)
| n1 | n2 |
|---|---|
| jack | elizabeth |
| john | chris |
| mike | joe |