我认为这符合您的描述：
select least(attr1_id, attr2_id) as attr1, greatest(attr1_id, attr2_id) as attr2from table tgroup by least(attr1_id, attr2_id), greatest(attr1_id, attr2_id) having bool_and(rating_d = 1) ;
我不理解查询中的其他表，因为您从拥有所需所有内容的单个表开始。
我认为这符合您的描述：
select least(attr1_id, attr2_id) as attr1, greatest(attr1_id, attr2_id) as attr2from table tgroup by least(attr1_id, attr2_id), greatest(attr1_id, attr2_id) having bool_and(rating_d = 1) ;
我不理解查询中的其他表，因为您从拥有所需所有内容的单个表开始。
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
