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

CREATE TABLE test_table (id varchar(10));
 hidden batch(es)


INSERT INTO test_table (id) VALUES (1);
1 rows affected
 hidden batch(es)


INSERT INTO test_table (id) VALUES (2);
1 rows affected
 hidden batch(es)


INSERT INTO test_table (id) VALUES (3);
1 rows affected
 hidden batch(es)


with a as ( select * from test_table ) select '=' + string_agg(id, ', =') within group(order by id) as where_clause from a
where_clause
=1, =2, =3
 hidden batch(es)