SQL Server 2014

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

create table tgCity (cityId int, city varchar(20));
insert into tgCity values(1, 'foo');
1 rows affected

insert into tgCity values(2, 'foo');
1 rows affected

insert into tgCity values(3, 'bar');
1 rows affected

select * from tgCity;


cityId
city


1
foo

2
foo

3
bar


DELETE t
FROM tgCity t
WHERE EXISTS (
    SELECT 1 FROM tgCity t1 WHERE t1.city = t.city AND t1.cityId < t.cityId
)
1 rows affected

select * from tgCity;


cityId
city


1
foo

3
bar