MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table1 (
  `ID` VARCHAR(100),
  `Val` VARCHAR(100),
  `Val2` VARCHAR(100),
  `Val3` VARCHAR(100)
);
INSERT INTO table1
  (`ID`, `Val`, `Val2`, `Val3`)
VALUES
  ('1','100','200','90'),
  ('2','100','200','10'),
  ('3','100','200','20'),
  ('19','100','200','20'),
  ('4','20','100','55'),
  ('5','20','100','10'),
  ('6','112','100','20'),
  ('7','112','100','20'),
  ('8','90','200','90'),
  ('9','30','90','180'),
  ('10','30','90','29');
select t.*
from (
  select val, val2
  from table1
  group by val, val2
  having count(*) > 1
) t1 inner join (
 select val, val2, val3
  from table1
  group by val, val2, val3
  having count(*) = 1
) t2 on t2.val = t1.val and t2.val2 = t1.val2
inner join table1 t on t2.val = t.val and t2.val2 = t.val2 and t2.val3 = t.val3


ID
Val
Val2
Val3


1
100
200
90

2
100
200
10

4
20
100
55

5
20
100
10

9
30
90
180

10
30
90
29


select distinct t.*
from (
  select val, val2
  from table1
  group by val, val2
  having count(*) > 1
) t1 
inner join (
 select val, val2, val3
  from table1
  group by val, val2, val3
  having count(*) = 1
) t2 
on t2.val = t1.val and t2.val2 = t1.val2
inner join (
 select val, val2, val3
  from table1
  group by val, val2, val3
  having count(*) = 1
) t3 
on t3.val = t1.val and t3.val2 = t1.val2 and t3.val3 <> t2.val3
inner join table1 t on t2.val = t.val and t2.val2 = t.val2 and t.val3 in (t2.val3, t3.val3)


ID
Val
Val2
Val3


1
100
200
90

2
100
200
10

4
20
100
55

5
20
100
10

9
30
90
180

10
30
90
29