我认为这符合您的描述:
select least(attr1_id, attr2_id) as attr1, greatest(attr1_id, attr2_id) as attr2
from table t
group by least(attr1_id, attr2_id), greatest(attr1_id, attr2_id)
having bool_and(rating_d = 1) ;
PostgreSQL-选择条件成立的distinct(column1,column2)
我认为这符合您的描述:
select least(attr1_id, attr2_id) as attr1, greatest(attr1_id, attr2_id) as attr2
from table t
group by least(attr1_id, attr2_id), greatest(attr1_id, attr2_id)
having bool_and(rating_d = 1) ;