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

select version();
version()
8.0.19
 hidden batch(es)


CREATE TABLE test ( x INTEGER, y VARCHAR (20) );
 hidden batch(es)


INSERT INTO test VALUES (1, 'xyz'), (1, 'xyz'), (1, 'xyz'), (2, 'abc'), (2, 'abc');
 hidden batch(es)


SELECT * FROM test;
x y
1 xyz
1 xyz
1 xyz
2 abc
2 abc
 hidden batch(es)


SELECT DISTINCT x, y FROM test;
x y
1 xyz
2 abc
 hidden batch(es)