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)
);
INSERT INTO table1
  (`ID`, `Val`, `Val2`)
VALUES
  ('1','1234  ','3175032612900004'),
  ('2','1234    ','3175032612900004'),
  ('3','1234 ','3175032612980004'),
  ('4','3123123','8888888888888888')
select Val,count(*) from table1 group by Val


Val
count(*)


1234
3

3123123
1


SELECT Val FROM table1 
			GROUP BY Val 
			HAVING count( Val ) > 1 


Val


1234


SELECT
	tb.* 
FROM
	table1 tb 
WHERE
	tb.Val2 IN (
	SELECT
		ta.Val2 
	FROM
		(
		SELECT
			t.* 
		FROM
			table1 t 
		WHERE
			t.Val IN ( 
			SELECT Val FROM table1 
			GROUP BY Val 
			HAVING count( Val ) > 1 ) 
		) ta 
	GROUP BY
		ta.Val2 
	HAVING
	count( ta.Val2 ) = 1 
	)


ID
Val
Val2


3
1234
3175032612980004