MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1
    (`dt` varchar(19), `ID` varchar(5), `Location ID` int)
;
    
INSERT INTO table1
    (`dt`, `ID`, `Location ID`)
VALUES
    ('21/03/2021 10:57:12', 'ab123', 1234),
    ('21/03/2021 10:57:12', 'ab127', 19826),
    ('21/03/2021 10:57:12', 'ab123', 1721),
    ('21/03/2021 10:57:12', 'ab124', 7656),
    ('21/03/2021 10:57:12', 'ab130', 1001),
    ('21/03/2021 10:57:12', 'ab335', 1991),
    ('21/03/2021 10:57:12', 'ab123', 0010)
;
DELETE FROM table1 WHERE ID IN (seLECt `ID` FROM (SELECT ID FROM table1) t1  GROUP BY ID HAVING COUNT(*) = 1)
SELECT * FROM table1


dt
ID
Location ID


21/03/2021 10:57:12
ab123
1234

21/03/2021 10:57:12
ab123
1721

21/03/2021 10:57:12
ab123
10

dt	ID	Location ID
21/03/2021 10:57:12	ab123	1234
21/03/2021 10:57:12	ab123	1721
21/03/2021 10:57:12	ab123	10