clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
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. 818513 fiddles created (9187 in the last week).

create table test(my_id int, col_a json, col_b json); insert into test values (5001, '["a", "b"]', null), (5001, null, '["c", "d"]');
2 rows affected
 hidden batch(es)


select t1.my_id, t1.col_a, t2.col_b from test t1 inner join (select my_id, col_b from test where col_b is not null) t2 on t1.my_id = t2.my_id where t1.col_a is not null;
my_id col_a col_b
5001 ["a", "b"] ["c", "d"]
 hidden batch(es)