Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table mytable (
  name	varchar(10),
  field	varchar(100),
  value varchar(10)
);

insert into mytable values
('A',	'Are they covered at the moment',	'TRUE'),
('A',	'Where does the client operate from',	'Home'),
('A',	'Additional information',	'x'),
('B',	'Are they covered at the moment',	'TRUE'),
('B',	'Where does the client operate from',	'Work'),
('B',	'Additional information',	'x');

CREATE TABLE



INSERT 0 6


select *
from mytable
where field = 'Are they covered at the moment' AND value = 'TRUE'


name
field
value


A
Are they covered at the moment
TRUE

B
Are they covered at the moment
TRUE



SELECT 2


select name, count(case when field = 'Are they covered at the moment' AND value = 'TRUE' then 1 end),
             count(case when field = 'Where does the client operate from' AND value = 'Home' then 1 end)
from mytable
group by name


name
count
count


B
1
0

A
1
1



SELECT 2


select name
from mytable
group by name
having count(case when field = 'Are they covered at the moment' AND value = 'TRUE' then 1 end) >= 1
       and count(case when field = 'Where does the client operate from' AND value = 'Home' then 1 end) >= 1


name


A



SELECT 1


select t.*
from mytable t
inner join (
  select name
  from mytable
  group by name
  having count(case when field = 'Are they covered at the moment' AND value = 'TRUE' then 1 end) >= 1
       and count(case when field = 'Where does the client operate from' AND value = 'Home' then 1 end) >= 1
) as s on s.name = t.name


name
field
value


A
Are they covered at the moment
TRUE

A
Where does the client operate from
Home

A
Additional information
x



SELECT 3

name	field	value
A	Are they covered at the moment	TRUE
B	Are they covered at the moment	TRUE

name	field	value
A	Are they covered at the moment	TRUE
A	Where does the client operate from	Home
A	Additional information	x