with cte as
(
select advertisementid, DateTimeRequested, IPAddress,
RN = ROW_NUMBER() OVER(Partition by advertisementid, DateTimeRequested, IPAddress order by advertisementid)
from RequestHistory
) delete from cte where RN > 1
with cte as
(
select advertisementid, DateTimeRequested, IPAddress,
RN = ROW_NUMBER() OVER(Partition by advertisementid, DateTimeRequested, IPAddress order by advertisementid)
from RequestHistory
) delete from cte where RN > 1