最新回答 / cloudsky3387380
select *from 表名where type=2unionselect t1.*from ( select * from 表名 where type=1 ) t1left join ( select * from 表名 where type=2 ) t2on t1.group_id=t2.group_idwhere t2.type is null
2021-08-09