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 |