with t as (
select 1 group1, 2 group2,3 group3
union all select 1,2,4
union all select 1,3,5
union all select 2,1,1
union all select 2,1,2
union all select 2,1,3
union all select 3,1,2
union all select 3,1,3
union all select 3,1,5
)
select * from t
where group1 in(select group1 from t where group3=5 )